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.)

 

[Triacona]

Dear Cindy,

Are you trying to send an e-mail of a specific query with the data?
If so:
I created a macro, with send object..

Object Type: Query
Object Name: MyQuery
Output format: Microsoft Excel 97-2003 (*.xls)
To: Me@me.com (if you leave this blank it should prompt you for recipients)
Edit Message: No


Hope this helps

Kind regards
Triacona

 

[cwindoma]

Thank you Triacona...but that's not what I'm trying to do. I have a document stored in a table as an 'attachment'. I need to pull that document into an email automatically.

 

[MazeWorX]

Do you mean you store the documents file path in your table?

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]