Email Attachment File Name

[GinaWhipp]

Then you need to usat in place of the name of the report and use the complete path to the file. AND if it were me I would remove the *dash* from the directory name. The file name is okay. So you would have...

"C:\BHRIR-AccessEmailEstimateAttachments\" & [LastName]&"Estimate"&[EID]&"-"[EstimateDate]&"BHRCopy.pdf"

...where the you have "rptEstimate". Again, you might need a DoEvents to give it time to save prior to the eMail grabbing it.