I really need some help if someone knows how, as have been tearing my hair out trying to work out how to rename a report from the name of the Report itself to one which takes the detail from a field called 'Invoice No' and renames the PDF to that before emailing.
I am no good with VBA (I dont even know how to start), so in a Macro I have the following. It all works just fine, but it sends the PDF name as 'InvoiceEmail' which is the report name itself. I really want it to change the name of the PDF to [Invoice No].pdf
Action 1: Open Report
Report name: InvoiceEmail
View: Print Preview
Where Condition: [Invoice No]=[Forms]![Invoices]![Invoice No]
Action 2: SendObject
Object Type: Report
Object Name:
Output Format: PDF Format [*.pdf]
To: =[Email]
Subject: =[Invoice No]
Message: blah blah