Access 2003 to Email issue.

[hansford dwight cornett]

I have a working Access 2003 form that has a button to open a report and send a email. This makes the report an attachment in the email. The name of the report is placed in the document as the name of the attachment. I would like to add the "variable" EmployeeName so that it appears in the attachment name. Is this possible and if so where and how do I code it to have this happen?

 

[Arvin Meyer [MVP]]

I used to be a mindreader, but those skills deteriorate with distance.
Without seeing your code, that's hard to do. If you're handy with VBA, try
using it to change the name of the attachment, or you can add the employee's
name when saving the file in the first place. There really isn't any way to
change the name of the attachment while it is attached.

Another thought. You can add the employee's name to the subject line of the
email.