Attachments to a docmd.sendobject ?

[Rick]

Hi. I need your advice as to how to attach a file to a message created by
the docmd.sendobject method. I attach an RTF document from a report in the
sendobject but have also created an XLS file from a query using the
docmd.outputto method. Is there a way I can attach this file to the same
message. I don't want to create an instance of Outlook since some clients
also use Outlook Express.
Thanks for your wisdom.
Rick

 

[Rick Brandt]

Hi. I need your advice as to how to attach a file to a message created by
the docmd.sendobject method. I attach an RTF document from a report in the
sendobject but have also created an XLS file from a query using the
docmd.outputto method. Is there a way I can attach this file to the same
message. I don't want to create an instance of Outlook since some clients
also use Outlook Express.
Thanks for your wisdom.

SendObject cannot do this. It can only "Send" "Objects" in your database.

 

[avner]

Dear Rick

i have a similiar problem sending an TXT file as Attached file via outlook 2002 , if sendObject can't do it can you help me find a solution (a VB Code ??) to do it

thank

avner