Sending Access report in the body of Outlook email - formatting.

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.
 
A

Alex Dybenko

Perhaps you send message in RFT format, try to send in HTML, look at outlook
properties
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top