Emailing snapshot turns report to jumbled characters

[as0125]

Hello all,

I've tried using all the suggestions provided in relevant threads to help me with this problem, but to no avail. Thanks in advance for any/all help....

I am able to successfull print out a report in the snapshot viewer. My problem is when trying to email it. Even when previewing the snapshot in the email (before sending it out), the text and formatting turns into jumbled characters. I've experimented with using both of these:

DoCmd.OutputTo acOutputReport, "RptMain",
acFormatSNP, "C:\Test.snp", True

and

DoCmd.OutputTo acOutputReport, ,
acFormatSNP, "C:\Test.snp", True

Both give me the same result. I've also tried using File>Send To, but I still get jumbled characters. I'd appreciate all suggestions!

 

[orna]

This works for me.

DoCmd.SendObject acReport, MyReportName, acFormatSNP, MailAddress,..........

It produces an .SNP file, opens your E-mail and attaches the file.

 

[as0125]

Thanks for the suggestion, but I'm still having the same problem.

The snapshot is created without a problem, when I used either "SendObject" or "OutputTo". The problem occurs when actually viewing the snapshot from within the email.