Attach PDF to email

[Guest]

I need advice on how to attach a PDF document to an email message. Steps 1
and 2 work well. Step 3 is where I need help...

1. Print an invoice to PDF and save it in the "\\myserver\invoices"
directory (thanks Mr. Lebans).
2. Use the DoCmd.SendObject to create and populate an email message.
3. Attach the .PDF invoice to the email message.

Thanks much.

bob

 

[Guest]

I forgot to mention that I am using Access 2000. bob

 

[Scott McDaniel]

I need advice on how to attach a PDF document to an email message. Steps 1
and 2 work well. Step 3 is where I need help...

1. Print an invoice to PDF and save it in the "\\myserver\invoices"
directory (thanks Mr. Lebans).
2. Use the DoCmd.SendObject to create and populate an email message.
3. Attach the .PDF invoice to the email message.

You can't send attachments with SendObject; you'll instead need use some other method of sending email. There are lots
of different ways, from automating Outlook to using CDO to using 3rd party utilities. Many VB/VBA devs use this:

http://www.freevbcode.com/ShowCode.asp?ID=7790

But be aware that this is VB-specific code, and you may need to tweak it to get it to work in Access. Tony Toews has a
good listing on his site:

http://www.granite.ab.ca/access/email.htm

Thanks much.

bob

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com