Sending attachment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SC - 21 Nov 2006 19:14 GMT

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.

Reply to this Message

Rick Brandt - 21 Nov 2006 19:19 GMT

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

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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

SC - 21 Nov 2006 20:13 GMT

Thanks Rick

> > 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
[quoted text clipped - 3 lines]
> would have to automate an external messaging library like Outlook or CDO. If
> you google these groups you should find many examples.

Reply to this Message