Attach PDF to email

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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
Click to expand...

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