Sending attachment

S

SC

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

SC

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