B
Bill Johnson
Access 2003
I am sending a report with a formatted Email message in SNP format using a
form. From time to time the report will show up on the email attached as an
Excel Spreadsheet with a system generated file name (and extension XLS). Of
course when you open the file, it appears as gibberish.
The command line in my code looks like this:
DoCmd.SendObject acSendReport, stDocName, acFormatSNP, msgTo, msgCC, msgBCC,
msgSub, msgBod
I've been able to fix the problem by changing the Caption in Report
Properties. This will correct the problem for awhile.
As this seems to be occurring more often lately I'd like to know if this is
documented anywhere and if there is a permanent fix I can apply.
Thanks!
Bill
I am sending a report with a formatted Email message in SNP format using a
form. From time to time the report will show up on the email attached as an
Excel Spreadsheet with a system generated file name (and extension XLS). Of
course when you open the file, it appears as gibberish.
The command line in my code looks like this:
DoCmd.SendObject acSendReport, stDocName, acFormatSNP, msgTo, msgCC, msgBCC,
msgSub, msgBod
I've been able to fix the problem by changing the Caption in Report
Properties. This will correct the problem for awhile.
As this seems to be occurring more often lately I'd like to know if this is
documented anywhere and if there is a permanent fix I can apply.
Thanks!
Bill