Macro to body of email from word & excel - can't get HTML format correct

I am trying to wite a macro that will allow us to create ad-hoc reports from data in excel. This macro will create an email for every unique code in column A. I then create the body of the email by pulling the info from a word file then adding the excel data.

The excel data is in HTML and looks great. The problem is that I cannot get any formatting for the word doc. Is there anyway of getting it to convert the word into HTML?

This is what it looks like (BTW - The formating for the excel part is fine) It's just the part that comes from word) I also attached my word doc and my excel data

This is a test Good Job So Long

Bob Johnson

CarrierPar
Carrier PctAward Freq EffDate AAWV TempPro
DestCity DestSt ######## ######## ######## ######## 1/0/1900 1/0/1900 1/0/1900 1/0/1900
BBBBB CRCR 1 WEEK ######## 4.9 N/A MIDWAY TN 2.00 0.0 2.0 0.0 0 0 0 0

This is what I want it to look like

This is a test
1. Good Job
2. So Long

Bob Johnson

CarrierPar
Carrier PctAward Freq EffDate AAWV TempPro
DestCity DestSt ######## ######## ######## ######## 1/0/1900 1/0/1900 1/0/1900 1/0/1900
BBBBB CRCR 1 WEEK ######## 4.9 N/A MIDWAY TN 2.00 0.0 2.0 0.0 0 0 0 0

Please Login or Register  to view this content.

Thanks

Chippy

Thanks for your help. That's worked. The only difference is that I used <pre> tags instead of the <p> tag