Problem creating HTMLBody infoormation in Outlook OlMailItem..

I have a VBA script which I'm running in Word to create emails containing the Word document and an  attachment.

It works fine except for the fact it uses

.Body = ActiveDocument.Content which removes all the formatting from the Word document.

I want to email the Word Document as it is, formatted.

I thought I would try .HTMLBody and do it that way, but I don't know  how to get the text contained in ActiveDocument.Content into an HTML Tag.

Any help appreciated.
Who is Participating?
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.

2 main options:

1. Use Word-Api  to convert to html
2. Send as attachment
chrisfixitAuthor Commented:
Ah thanks, any pointers to option one?

The thing is this is for a hotel.

 They are mailing their travel agents and the like and have a preformatted Word Document with their      logo etc..the attachment is the latest price list.

Up until now they have done it manually sending 20 or so at a time, but want to automate it.

They also send the info to some clients by Fax, and it's important to them that the email looks similar to the Fax.
Document.SaveAs(...) , with FileFormat set to WdSaveFormat.wdFormatHTML

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
chrisfixitAuthor Commented:
Thanks, I'm now trying to convert VBA to VB .NET ;-)
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

From novice to tech pro — start learning today.