Report attachment to email

[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.

 

[Gina Whipp]

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