Send email with attachment

[Bob Howard]

If I were to use the Lebans ReportToPDF software to create a PDF, what set
of Access 2003 protocols would I then use to send that PDF as an email
attachment? I poked around at the help screens, but I can't figure out how
to send an attachment that's a file.

Or ... is there another way to handle this? Can I just send the report
output as an email attachment without making it a PDF first?

Bob

 

[krissco]

If I were to use the Lebans ReportToPDF software to create a PDF, what set
of Access 2003 protocols would I then use to send that PDF as an email
attachment? I poked around at the help screens, but I can't figure out how
to send an attachment that's a file.

Or ... is there another way to handle this? Can I just send the report
output as an email attachment without making it a PDF first?

Bob

As far as I am aware, there are two methods of attaching an object to
e-mail. One easy (and not flexible), the other hard (and as flexible
as you need it to be).

Easy way:
Look up "docmd.SendObject" in MS' help.

Hard way:
Automate Outlook (assuming you are using Outlook). Here's an old post
that has the relevant code:
http://groups.google.com/group/micr...s/browse_thread/thread/3dd8386d1f0cf641?tvc=2


-Kris