Sending attachments in an email.

[cwindoma]

Hello all,

I'm trying to pull an attachment that is stored in a field in a table into an email.

I've tried the SendObject action in a macro, but it only allows for Objects (tables, querys, forms, etc.), not the 'values' stored in a data field.

So since it wanted an object, I tried pointing it to a query, but it only shows the query results...(ie: with a value of '1' in the attachment field), but you can't open it...it's not there.

I even tried to pull it into the Message field of SendObject with an expression:
=[myAttachment]
But it sensed my craftiness and foiled my creativity.

Seems like this would be a common problem, anyone have any insights on this?

-Cindy
(Access Beginner...
...please speak slowly.)

 

[SkipVought]

Hi,

Why not put your values in the message?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cwindoma]

Hello Skip...

The documents are pretty big, 3-10 pages. So it's beyond what I can represent in an email. Need to include the document since the email recipients need to approve that specific document.

Cindy

 

[SkipVought]

Then you need to generate a "document" to attach.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cwindoma]

Not quite, I have the document stored in a table, just need to pull it into the email.

Cindy