Sending Serial Email with PDF attachment

  • Thread starter Thread starter RSteph
  • Start date Start date
R

RSteph

I'm trying to use an Access Form to select options to build a query; this
query is then used to populate the "To" field of a serial e-mail. I fill in
the Mail Server, From Address, Subject, and Body values via fields in the
form. I'm trying to include an attachment; If I try to include a PDF
attachment, the attachment never goes through, and there is a block of random
characters at the bottom of the e-mail. If I try any other file type as an
attachment it works. I am currently using Access2003, and getting ready to
upgrade to Access2007.

Any suggestions on how to resolve this would be greatly appreciated. Thank
you.
 
RSteph said:
I'm trying to use an Access Form to select options to build a query; this
query is then used to populate the "To" field of a serial e-mail. I fill in
the Mail Server, From Address, Subject, and Body values via fields in the
form. I'm trying to include an attachment; If I try to include a PDF
attachment, the attachment never goes through, and there is a block of random
characters at the bottom of the e-mail. If I try any other file type as an
attachment it works. I am currently using Access2003, and getting ready to
upgrade to Access2007.

Any suggestions on how to resolve this would be greatly appreciated. Thank
you.
Click to expand...

Here is a link with a code example. The sample has a .txt attachment, but works with a .pdf as well. I just tested it(access 2003). Hope this is what you're looking for.

http://www.jephens.com/2007/05/13/how-to-send-e-mail-from-ms-access-using-outlook
 
Last edited:
Back
Top