Unanswered: Send Report as attachment to email - auto fill "To"
I have a report that I created, and I want to hit the Command button on that report to send and email. I have the email part figured out, just dont know how to auto fill the "to" section based on the filter used for the report.
the report is filtered by "location"
The location name is at top of the report.
The location has an email address in the "locations" table that is recorded as "email"
The email does not appear on the report anywhere but I can add it to the query that filters it and make it invisible if that is easier.
Any thoughts or suggestions on how to auto fill the "to"???
Thanks, I appreciate the help.
Can you explain how to put the information from the the form into the "to" section.
I have a button on the report that will email the report in pdf format (I used Macro Builder).
I am new to access so it may be very simple but I dont know how to do it.