Change file name when emailing a report

SoCal

Registered User.
Local time
Today, 13:07
Joined
Nov 7, 2012
Messages
16
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!
 
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.
 

Users who are viewing this thread

Back
Top Bottom