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
 
Back
Top