Sending attachment

G

Guest

Can anyone tell me how to send an attachement using code in VBA. I am aware
of the SendObject function however I am trying to output a report to Adobe
and email it to a distribution list. I can't seem to get it right.
 
R

Rick Brandt

SC said:
Can anyone tell me how to send an attachement using code in VBA. I am aware
of the SendObject function however I am trying to output a report to Adobe
and email it to a distribution list. I can't seem to get it right.
Click to expand...

You cannot include an attachment from the file system with SendObject. You
would have to automate an external messaging library like Outlook or CDO. If
you google these groups you should find many examples.
 
G

Guest

Thanks Rick

Rick Brandt said:
You cannot include an attachment from the file system with SendObject. You
would have to automate an external messaging library like Outlook or CDO. If
you google these groups you should find many examples.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CDO message 2
Send more then one attachment in Email 1
Using both Outlook and Outlook Express 2
email recipient address shows twice 2
Automatic Email using a field on a form 5
Why is it so hard to get an Adobe Distribution license (for .msi installers) 4
Email Attachment 1
Access Access - SendObject, Renaming table that's being attached. 0

Top