Send Email

[learning_codes]

Hi

I just want to know if there is a way to create the name of Excel
Spreadsheet file from the field name instead of query name

DoCmd.SendObject acQuery, "Results_Completed",
"MicrosoftExcelBiff8(*.xls)", "(e-mail address removed)", "", "",
"(IDNum - " & strIDNumber & ")" & " Data Results.", "", False

This gives me the file like "Results_Completed.xls added to my email
message.

What am I looking for like :

-----> "245.xls" instead of "Results_Completed.xls".

IDNum (field name in a query name)
Results_Completed (Query name)

Your help would be much appreciated.
Thanks