DoCmd.SendObject, Customize object name

Hi

When we use DoCmd.SendObject, the object name is always the same name of table, query or report.



Can we customize object name to something else more descriptive?

For example

If I send the report "SalesPerSalesman" about John Smith,

the object name now is "SalesPerSalesman.pdf"

If i send the report "SalesPerSalesman" about Maryann Johns,

the object name would be again "SalesPerSalesman.pdf"



However , the object name I would like "SPS_JohnSmith.pdf"

and the report for Maryann Johns, I would like as object name "SPS_MaryannJohns.pdf"



Is this feasible ?







Syntax

DoCmd.SendObject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile



ObjectName – Name of table, query, Report etc.

DoCmd.SendObject, Customize object name