Problem with OutputTo

[Neil Ginsberg]

I was using SendTo to e-mail a report in my database. However, the client
uses Outlook with Exchange, which doesn't allow attachments to be sent via
SendTo. So I converted it to MAPI code. The new code requires me to first to
an explicit export of the report using OutputTo (to a snapshot format), and
then to attach the created file to the mail message. When I perform the
export using OutputTo, I get the message:

"Expression is typed incorrectly, or is too complex to be evaluated.
Example, a numerical expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables."

I have two other reports that work fine with the new code. Only with one
report (which does have a vary complex query as its recordsource) do I get
this error.

It seems strange that SendTo would be able to create the snapshot file, but
OutputTo does not. I tried other formats (RTF, etc.), but the results are
the same.

Any ideas as to how I can avoid this error or find some other way to export
the report for attachment to an e-mail file? I am using Access 2000 on
Windows XP.

Thanks!

Neil

 

[Michael Hopwood]

Why not post the code?

 

[Neil Ginsberg]

Well, there's not much to post; but here it is:

DoCmd.OutputTo acOutputReport, "Report1", acFormatSNP,
"c:\myfiles\report1.snp", False

Neil