M
Michelle-Tigerfish
I am trying to send an Access report in the body of an Outlook email rather
than as an attachment. I find I can create a Word document using the
following code:
DoCmd.OutputTo acReport, stDocName, acFormatRTF, stOutputDocName & ".rtf",
True
Then I use the Word Send command, then Send To Recipient to send the Word
document as an email message. The report has data formatted in columns.
When the message reaches the recipient, sometimes the data in the message is
formatted exactly as it was sent, other times the formatting is totally off.
Does anyone have any suggestion how to create the message so that the
formatting is consistent?
Thanks.
than as an attachment. I find I can create a Word document using the
following code:
DoCmd.OutputTo acReport, stDocName, acFormatRTF, stOutputDocName & ".rtf",
True
Then I use the Word Send command, then Send To Recipient to send the Word
document as an email message. The report has data formatted in columns.
When the message reaches the recipient, sometimes the data in the message is
formatted exactly as it was sent, other times the formatting is totally off.
Does anyone have any suggestion how to create the message so that the
formatting is consistent?
Thanks.