Solved

VBA Outlook Send E-mail as HTML

Posted on 2013-01-24
6
559 Views
Last Modified: 2013-02-09
Hi,

I am sending an e-mail from Outlook using vba. I use the HTMLBody property so the e-mail text is formatted using HTML.

The code works fine and send me a e-mail fine. Format is fine. However when I send it to a group of people the e-mail displays all the HTML tags and just looks like a load of gibberish!

Can someone please tell me how to fix this?

Thanks,
M
0
Comment
Question by:mcs26
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 38817064
Hi, mcs26.

The HTMLBody property contains the HTML, but doesn't set the email format to HTML.  Are you also setting the BodyFormat property to olFormatHTML?
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 38817490
'M'


I have nothing to add as I too believe the bodyformat will resolve your issue .. if not then of course get back to us, (an example of your code will help).  My primary purpose is to say ...

David

Long time no see, I trust you are well?

Chris
0
 
LVL 76

Expert Comment

by:David Lee
ID: 38818178
Hey, Chris.

I got busy with some other things and stopped answering questions altogether for just over a year.  Decided it was time to get back in the game.  I am well, thanks.  How about yourself?

Cheers!

David
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 38818223
Well also but slowed down a lot on the site, (general weight of work / pace of life) see you around no doubt.

mcs26 ... back to you ;o)

Chris
0
 

Author Comment

by:mcs26
ID: 38830777
Hi Guys,

Sorry for the delay in getting back to you. Turns out the issue was when I sent the e-mail to a group using the group distribution name it would not send the e-mail as html. However if I sent the e-mail and listed the individual users (8 people) it works fine.

No idea why that is but now works so happy now!

Cheers,
M
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Outlook 2016 10 45
Exchange 2007 Outlook 2010 1 25
office 2010 not starting even in safe mode 9 177
exchange, outlook, calendar 11 28
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question