Attach report.snp to Email Error

[Bill Johnson]

I've had this happen to me before, after working for months on end, Access
hiccuped one day and instead of attaching a report to my email in snp format,
it assigns its own name, "CDB437.xls"

This is the command being sent: DoCmd.SendObject acSendReport, stDocName,
acFormatSNP, msgTo, msgCC, msgBCC, msgSub, msgBod

the stDocName is : "rptSuspenseDetailAllbyRRUU"

if I change the extention of the file to snp : "CDB437.snp" it will open
properly. Any clue what's happening here?

 

[Bill Johnson]

I forgot to mention, I went to a co-workers workstation and ran the same
procedure. The result was it attached the correct filename. The code
appears to be working fine, perhaps something within my copy of Access is
corrupted?

 

[Bill Johnson]

I was able to fix this by changing the Report Caption (the name that Access
uses when attaching the report) in the Report Properties. It doesn't
explain why the problem began in the first place, or why it should work on
another workstation, but it is something I've noted in the VB code in case it
ever comes up again.