VBA code to send Outlook email with HTML text no longer working

Hello all

I have a User Form which when ran should generate and display an Outlook email with a distribution list and the contents of the form in to the body of the mail. It was built on an XP machine running Office 2003 and worked perfectly, we're now on Win 7 at work running 2010 and it no longer works as it should.

When run in Excel 2010 and Outlook 2010, the email opens, populates all names in the email distribution list and adds the email subject, however the body of the mail is blank. I'm afraid my VBA knowledge is fairly limited so I'm not able to work out why it no longer works, I'd very much appreciate your thoughts on the below or if you know of any other reason why it would stop working in 2010

Many thanks in advance for any advice

Twaddy

Please Login or Register  to view this content.

The code then details the HTML code after 'HTMLbody =' for the email contents section, essentially it sets the font, specifies some text as bold, adds lines breaks etc and pulls in information from certain fields on the user form to create the body of the mail. Unfortunately the forum won't let me past the firewall to post it with the full HTML code, code even when I try and wrap it with HTML tags, I must be doing something wrong. If anyone can advise how I can update the post with the full code I'd appreciate it

The code then continues and completes with...

Please Login or Register  to view this content.

The code itself worked perfectly on Excel 2003 so I don't believe it's that, it doesn't Debug when ran either, it just creates the email with the body of the mail blank

Any thoughts would be very welcome

Twaddy

Hi gmr4evr1

Thanks for your reply, unfortunately it didn't work for me, the email opens ok but still nothing appears in the body of the email

I'm starting to wonder whether my work has placed restrictions on Outlook or something that's preventing the HTML text being formatted

Thanks anyway for your reply

Twaddy

Hi gmr4evr1

Apologies for the delayed reply

I've discovered that the code works perfectly when using my work laptop at home through my wifi connection, however not when in the office when connected via a network cable, so I can only presume it's linked to security settings in the office.

It doesn't really make sense as I'm required to connect to the company network securely when at home also

Thanks anyway for your replies and offer of help

Twaddy