eMail Snapshot, change object name being attached

L

Larry Jones

I am successfully emailing a snapshot report. But, when the email
application comes up, with the attached snapshot, it has the name
"rptItinerary.snp".

Now, while this may be good naming standards for a database,
"rptItinerary" will probably look funny to a user.

If I use the OutputTo option, to create the Snapshot by itself, I can
give it a decent name:
DoCmd.OutputTo acReport, "rptItinerary", "SnapshotFormat(*.snp)",
strReportName

But then I don't know how to email that file from within Access.

So, I use the SendObject statement to email the report as a snapshot:
DoCmd.SendObject acSendReport, "rptItinerary", "SnapshotFormat(*.snp

But I can't seem to change the name.

So, can someone tell me how to email the file I create with the
OutputTo statement, OR change the name of the attachement in the
SendObject statement?

TIA
 
Top