Change file name when emailing a report

[SoCal]

Hi All,

I have looked around for the answer, and am still confused, so help please.

I am using Access 2010, and understand how to email a report or save it as a pdf. My problem is when I email the report, and select to send it as a pdf, the name of the file is the same as my report (by default).

How can I email this report in pdf, and name the file as "FirstName_LastName_OrderDate.pdf"?

Thanks!

 

[Isskint]

I am sure this is not possible in one function. However i do this already by using the CopyObject method to create a new version of the report with the name i want. Then send it, then use DeleteObject to delete the object. Now you do need to ensure that someone (or some code) regularly compacts the DB as i believe this bloats the DB.