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.