SendObject with dynamic attachment name

[chris.williams]

Hi - I am attempting to send a PDF of a report via email and the SendObject function but I don't know how to create the attachment with a dynamic name. What happens is the name of the report gets passed to the name of the attachment.

DoCmd.SendObject acSendReport, "rpt_Certificate", acFormatPDF, "replace.me@domain.com", , , Subject, Body, Yes, ""

What I would like to do is name the attachment from a field.

Something similar to this:

DoCmd.SendObject acSendReport, "rpt_Certificate" [TaskSR] & ".PDF", acFormatPDF, "replace.me@domain.com", , , Subject, Body, Yes, ""

[Stingaway]

I do this by previewing the report and renaming the report in the OnLoad property of the report, but I am sure you could do something similar bypassing the need to open the report.

Basically I set the report caption by populating a field on my form with the Customer Name (which will also be part of the report name) and add the order number (also a text field on the form) and date information to the report name as follows:

Me.Caption = [Forms]![frm_Main]![txt_Cust_Name_for_Report] & " Order " & [Forms]![frm_Main]![txt_OrderNum] & " - Schedule as of " & Date

The final product sends the attachment with the dynamically assigned name.

[chris.williams]

Thanks - that worked did exactly as you said. It doesn't work when it's sent through SendObject though. Anyone know how we can put the two together?

[Stingaway]

How are you firing the send object? Control button? You can do the same thing by defining the report name in the code (instead of the onload event) before you execute the send object command. Pass the report name as the variable and you should be good to go.

[chris.williams]

I am doing it via a click event. I have not been able to determine where I place the variable in the attachment name.

Any clues?