Importing from Excel with HTML Formatting

K

KEN

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. <html>text</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
 
D

Diane Poremsky [MVP]

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[
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. <html>text</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?

thank
Click to expand...


--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]
 
K

KEN

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.


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. <html>text</html> which makes is super hard to read.
Click to expand...
Query: Does anyone know how to import text based messages into Outlook
and have the message be in HTML format?
Click to expand...
thanks
Click to expand...

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

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert HTML into an Outlook 2021 email 0
Office 365 Outlook adding unwanted HTML to Email Body 0
Default format type HTML Outlook 2013 0
How to export html text as word document with specific size and orientation 0
Issue with outlook 2007 web access cant change from HTML 0
Template with fields and premade texts.. 0
Excel does not accept text format! 0
MS Project Import Error Row 1 Column 5 2

Top