E-mail a PDF file from MS Access 2003

[ilokana]

Hi,

I have a report that generates personalized letters. How can I attach these personalized letters (in PDF format) to their corresponding e-mails using MS Access 2003?

Please help. Thanks.

ilokana

[CitizenKane]

Hi,

I have a report that generates personalized letters. How can I attach these personalized letters (in PDF format) to their corresponding e-mails using MS Access 2003?

Please help. Thanks.

ilokana

Hi Ilokana

I am currently using vb code wrote by Stephen Lebans which does exactly what you are looking for. You can download the class library (.dll) from the following site and the code is commented very well to help you. Hope this helps

http://www.lebans.com/reporttopdf.htm

[ilokana]

I already have pdf converter in my computer. I just know how to convert each letter to pdf automatically. Is there a code to put into my database so I don't have to name everytime I store them to pdf? Thanks.