plain text format when emailing reports

[Rick B]

Hello. Hopefully this is an Outlook question, not an Access question...

When I preview a report from Microsoft Access and right-click on the screen
and select "send to" and "mail recipient (as attachment)" the system asks me
which format to send. I can send the attachment in a "Rich Text Format" a
"Snapshot Format" a "DOS Text Format", etc.

No matter which format I choose, the actual email message that is created is
in "Plain Text" format. Our company standard dictates that all emials are
sent in HTML format. This allows others to forward them back and insert
comments into the text of the email which is color-coded based on the person
inserting the comments and includes the user's name.

All my Outlook settings appear to be using HTML as my default mail format.

Can anyone tell me how to fix this without having to modify the format of
the message before sending it every time?

Thanks, Rick B

 

[Sue Mosher [MVP-Outlook]]

This is normal behavior, because the technique you're using invokes Simple
MAPI, not the Outlook editor. The solution would be to write Access VBA code
to save the current report as a file (you might want to ask about that in an
Access forum) and create the Outlook message and attach that file.