Renaming a report before SendObject

[kingdoz]

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

[June7]

You could try OutputTo instead of SendObject
http://social.msdn.microsoft.com/For...5-2984825a60be

[kingdoz]

Ctually I just found out a much easier way to do it.

In the report itself, In Properties, In Format, if you fill in the Caption then it will SendObject with the Caption Name. The way I did it is by writing a tiny peice of VBA.

I clicked Event Tab in properties, then chose On Load, and put in just 1 line of code:

Reports("InvoiceEmail").Caption = [Invoice No]

Perfect, now it renames the PDF to the Caption Name