send email from outlook with multipart/alternative -- 1 html copy + 1 plain text copy

I'm composing customized emails from Access using VBA. They're columns of numbers and will only display properly in a fixed width font. I thought plain text usually would display in Courier font, which would work fine. After send emails from several users' Outlook 2003, I see that although the emails are all going out as plain text, everything's not in Courier 10 -- and the proportional fonts don't look right. Some users show what was sent as Times Roman or Arial, some show what was received this way. So the columns don't line up properly.

I assume there's no way to force the recipient to use a specific font on a plain text email. So I thought how about sending an HTML email using Courier as the font, then also including a plain text email in case the user can only read plain text. Is there a way to send this "multipart/alternative" type of email from Outlook 2003? Or is the only way to control it going to be send HTML using Courier as the font and then figure out the recipients who can't receive HTML and send them plain text, hoping for the best?
LVL 4
GordonPrinceAsked:
Who is Participating?
 
Patrick MatthewsConnect With a Mentor Commented:
GordonPrince,

Seems to me that the simplest approach would be to have your output come out as a report, and then add the report as an attachment to the email.  IMHO, that is the best way to guarantee the fidelity of the output...

Patrick
0
 
GordonPrinceAuthor Commented:
What format would you suggest for the report? So it can be read on any device that might be used to read email? That's the rub -- I'm sending it to hundreds of people, every email is in the same layout but has different information on it. And people may be trying to read it with Outlook, Outlook Express, web based mail, smart phones, etc.
0
 
GordonPrinceAuthor Commented:
Even sending a .txt file as an attachment could confuse some people when they get the pop-up "choose a program to open the attachment with". Some people won't even accept attachments, so they won't try to open the .txt file. But the .txt file attachment might be as likely to work as anything. Unless a user has set Word as their .txt file viewer and Word changes the font when they display the attachment...
0
 
Patrick MatthewsCommented:
I would suggest PDF
0
 
GordonPrinceAuthor Commented:
I wound up using the Outlook VBA EditorWord object, then setting the font to Courier New there. The end user wanted the body in the body, not as an attachment.
0
All Courses

From novice to tech pro — start learning today.