Report attachment to email

  • Thread starter Thread starter hdcornett
  • Start date Start date
H

hdcornett

I have a event procedure from a button on my form that sends a report through
email to a specific designee. This works fine. The report when saved as an
attachment into the email merely states the name of the report. I want to
add the variable EmployeeName into the process so that the document that is
being attached will be identified in the email as EmployeeName Report Name.
 
hdcornett,

Not sure how you are doing this because no code here. However, I would
imagine you are doing this from a form? And you are using a button to send
your eMail? Try adding something like....

"ReportName" & Me.FieldThatContainsYourEmployeeName

OR

"ReportName" &Me.ComboBox.Column(1)

OR

Post back with more details...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 to Email issue. 1
Emailing multiple reports in Access 0
Email Report as Attachment with Voting Buttons 2
attachement with email 1
Email settings through Access 2003 1
rename attachment 1
Report as email message rather than attachment 6
Create a button in a form to email a report 3

Back
Top