VBA code to EmailDatabaseObject with Filename and subject specified by report field

[dwiechensd]

Hello,

I have a database I'm trying to enhance with user friendly buttons. I have a report (DWRReport) that runs from querry (DWR Querry) based on table (DWR:Table). Additionally I use form (DWR Entry). The report DWRReport currently has Parameters for field "Dyna Drill WO". I'd like to create a button on the form DWR Entry that will run a macro pulling up the report, attaching the PDF of the report to an email, and renaming the filename of that PDF to the field "Dyna Drill WO". Also, I'd like to make the subject of the email being sent the field "Dyna Drill WO".

Sending an email "DWR Report" for EVERY DWR sent is going to create a problem for the people trying to search for them.

Forgive me, this is my first post so I'm not sure what other information is needed to assist me. I don't have any code currently. Though I have figured out how to email the report through the macro builder, there doesn't seem to be a way to specify any information like I'm needing. This leads me to believe that I need VBA code. As I'm new to access, understanding how to write the proper syntax to get the desired result is proving more than I can handle :)

Thank you for your help!
Danielle

[Seth Schrock]

The basic steps you are going to need to take are to generate the PDF of the report and save it to a specified location and then create the email with the attachment.

First off, you can either prompt the user where they want to save the PDF or you can just have that hardcoded into the code. Then on the email, are you using MS Outlook or some other email system?