Results 1 to 5 of 5
  1. #1
    schuchertc is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2011
    Posts
    3

    Smile Use VBA to send report via email (similar to mail merge only though email)

    I have a form with user contact info and other stuff that I need to track where I have set up a button to add the user to Outlook, a button to send them an email, and a button filtered by their user ID so that I can generate an individual report on the form for each user. I can create a .pdf version of the report and email it but I either have to save it and use the button to open the email then manually attach the report or I can email it to the person directly from the .pdf version but I have to then add their email address. Either method takes a lot of time to complete which adds up when I have multiple reports to multiple users that need sent out at once.



    Is there a way to combine this into one smooth operation where I can use VBA to take the report, use the email address and the user ID as criteria to generate individual reports that will loop through and email the correct report to the correct user automatically?

    Typically I have to generate the report based on set criteria then mail a hard copy via snail mail each year to people who still have outstanding classs that they need to complete. This is not critical but I just want to know if it can be done.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It certainly can be done. See if this gets you started:

    Emailing a different report to each recipient
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    schuchertc is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2011
    Posts
    3

    Thank you!

    I'll work on this and let you know how it is progressing.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    schuchertc is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2011
    Posts
    3

    Smile

    Thank you! I don't know where I'd be without forums. It's nice to have somewhere to go when you are stuck or trying to figure out a new way of doing something.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to send filtered report via email
    By degras in forum Reports
    Replies: 4
    Last Post: 03-31-2011, 09:09 AM
  2. send email to email addresses in database?
    By cnstarz in forum Access
    Replies: 5
    Last Post: 03-02-2011, 09:46 PM
  3. Email from report to Email body
    By Ehmke66 in forum Programming
    Replies: 4
    Last Post: 01-03-2011, 01:06 PM
  4. Replies: 9
    Last Post: 10-09-2009, 08:15 AM
  5. Replies: 1
    Last Post: 05-01-2009, 07:33 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums