locked
sending pdf as attachments using outlook automation RRS feed

  • 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
    Tuesday, February 15, 2011 9:23 AM

Answers

All replies

  • 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
    • Marked as answer by Cire1507 Saturday, February 19, 2011 11:54 AM
    Tuesday, February 15, 2011 12:09 PM
  • 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.
     
     
    Cheers,
     
    Armen Stein
    Microsoft Access MVP
    www.JStreetTech.com
     
     
    Tuesday, February 15, 2011 11:23 PM
  • 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/

    Wednesday, February 16, 2011 1:18 AM