SendObject Naming Option?

[GDub58]

I have a SendObject XLS Email attachment that originates
from an Access query called "Email Roster". Within
the "EMAIL" command button code, is there a way to
programmatically alter the XLS file attachment name to Date
() & ".xls" instead?

Thanks

 

[MacDermott]

AFAIK this is not available within SendObject.
SendObject is sort of like its own little wizard; it performs a pre-set
sequence of tasks as one chunk.
You could simulate this action by using OutputTo to create an xls file, then
Name to rename the file, but then you'd probably need to automate Outlook or
Exchange to send it as an attachment...

HTH
- Turtle