sending pdf as attachments using outlook automation

Question

every month we receive about 300 pdf files that contain invoice data. the pdf's are named in such a way that i can obtain

the e-mail addresses of the users  who need to receive the pdf's. I would like to develop an application that picks up all these

pdf's one by one and then send them as attachment to the users using outlook automation.

what would be the best approach to accomplish this?

 

Many thanks.

 

---

Rik

Answer 1

I would look at ron Debruin's webpage for excel.  The excel code and the access code would be the same in this case.

 

http://msdn.microsoft.com/en-us/library/ee834871(office.11).aspx

---

jdweng

Answer 2

Although I haven't used it myself, a client of ours uses this utility

to "burst" a long PDF report into separate smaller PDFs and email them

to individual email addresses.  Apparently the email addresses can be

hidden right in the report.

 

http://www.safe-install.com/programs/pdf-explode.html

 

Cheers,

 

Armen Stein

Microsoft Access MVP

www.JStreetTech.com

 

 

Answer 3

Cire1507 wrote:

every month we receive about 300 pdf files that contain invoice data. the pdf's are named in such a way that i can obtain

the e-mail addresses of the users  who need to receive the pdf's. I would like to develop an application that picks up all these

pdf's one by one and then send them as attachment to the users using outlook automation.

what would be the best approach to accomplish this?

You will need to use the Dir command to loop through the folder to fetch
the file names and decide how to handle the files.   You can test the
loop by doing a debug.print of the file name as you loop through the
folder.

Then you need to decide on a method of emailing attachments.
SendObject won't work as it doesn't handle attachments.  If all your
users have Outlook then that's definitely one approach.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony

---

Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/