I have RTF data stored in ms access table, When this data is sent to outlook it displays html like code. How to make RTF text appear into outlook email from Access table.

Following is what appears in outlook. Please help in converting this back to RTF.

• &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Received Scope Acceptance<br>
• &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Started NCP for internal orders<br>
• &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Received internal orders<br>
Router Delivered at customer site. &nbsp;<br>
Legends/Telstra Acronyms :<br>
TRPB: Transmission Path Build / Line Build<br>
if the order is for carriage only then the Line is built from closest exchange to customer premises in MDF.<br>
If order is for router or switch then router /switch configuration is built and loaded into Telstra servers.<br>
If the order is TIPT/SIP then phone credentials and other phones/SIP related configuration is built and loaded into Broadsoft. Also, SIP credentials are prepared and sent to customer.<br>
TEQP: Tech Equipment / Device Connection Date<br>
Terminating equipment such as NTU, Router, switch or SIP/TIPT equipment is connected and Tested.<br>
DSPS: Digital Service Packet Switching Test/ Device Management Date<br>
The service undergoes the final testing and officially handed over to the customer.<br>
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
How are you sending this to Outlook? If you're using Automation, you have to set the HTMLBody, not the Body, if you want this to appear as formatted text in Outlook:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
Microsoft decided a number of years ago that HTML is RTF.  Never mind that there was already a format called RTF.  What you are seeing is what you are going to get.  You need to get it into the HTML editor in Outlook and I don't know how to do that.
MannafAuthor Commented:
I was using .Body. All good after changing that to .HTMLBody. Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.