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
