Where is my FormatSNP in my mail ?

T

Tschuß

Hi,

I have the following code in my report:
DoCmd.SendObject acSendReport, "CEM_Report", acFormatSNP,

But, in my mail, the attached file is not CEM_Report.snp but a file
like ' - CDB65.xls'

Why I haven't a file with the snp format ?
 
J

jahoobob

Try:
DoCmd.SendObject acReport, "CEM_Report", "SnapshotFormat(*.snp)"
"[email protected]", "", "", "", "", False, ""
Just like checking to see if the TV is plugged in when it doesn't work
check to see that CEM_Report is there.

I have found the easiest and most reliable way to create code is t
convert a macro that you know works. Macros force you to selec
certain things like reports that actually exist and will pick th
correct format for code from what you entered.
Hope this helps,
Bob
 
R

Robert Wright

You may want to check out the KnowledgeBase article

PRB: Sending Mail With SendObject Contains an Attachment With an Incorrect
File Name or File Type.
Article ID : 555020
Last Review : December 6, 2003
Revision : 1.0

Robert Wright
 
T

Tschuß

Ok Thanks. I will try but I found that with special characters the
format snp is not possible. So I change the caption of all my reports
and everthing is fine now
 
Top