Importing from Excel with HTML Formatting

A client of mine has been on a web based system for email and CRM.
They now what to use Outlook and a proprietary CRM system. The online
system has sent us a SQL file with all the emails and I can put those
out so we can put them in Outlook, the problem is that the body of
each message is in HTML and when we import the body of the message is
plain text i.e. htmltext/html which makes is super hard to read.

Query: Does anyone know how to import text based messages into Outlook
and have the message be in HTML format?

thanks

It's not possible to do that using normal import methods. You might be able to do it using VBA - the ones who can advise on that are "down the hall"

KEN[1
wrote on Mon, 16 March 2009 17:25]A client of mine has been on a web based system for email and CRM.
They now what to use Outlook and a proprietary CRM system. The online
system has sent us a SQL file with all the emails and I can put those
out so we can put them in Outlook, the problem is that the body of
each message is in HTML and when we import the body of the message is
plain text i.e. htmltext/html which makes is super hard to read.

Query: Does anyone know how to import text based messages into Outlook
and have the message be in HTML format?

thanks


--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:

Thanks a bunch for the response. Is it not possible from any type of
file or just Excel?

I posted the same questions "down the hall" in the vba area, thanks
again.


On Mar 16, 3:58*pm, Diane Poremsky [MVP] outlookmvp[at]msn[dot]com
wrote:
It's not possible to do that using normal import methods. You might be able to do it using VBA - the ones who can advise on that are "down the hall"

KEN[1

wrote on Mon, 16 March 2009 17:25]A client of mine has been on a web based system for email and CRM.
They now what to use Outlook and a proprietary CRM system. *The online
system has sent us a SQL file with all the emails and I can put those
out so we can put them in Outlook, the problem is that the body of
each message is in HTML and when we import the body of the message is
plain text i.e. htmltext/html which makes is super hard to read.

Query: Does anyone know how to import text based messages into Outlook
and have the message be in HTML format?

thanks

--
Diane Poremsky [MVP - Outlook]
Outlook Tips:http://www.outlook-tips.net/
Outlook & Exchange Solutions Center:http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange: