Copy contents and format from excel cell into body of outlook e-mail

[dana.oliva]

Hello folks,

I'm having difficulty copying Data and formatting from a specific cell into the body of an e-mail. I'm using the following line to copy the cell:

.Body = Workbooks(workbookname).Sheets(3).Range("A1")

It copies the cell data just fine it's the formatting that I loose

Any help or guidance you could provide would be greatly appreciated.

Thanks in advance,

Dana

 

[Andrew Poulsom]

Using HTMLBody should do the trick:

http://www.rondebruin.nl/mail/folder3/mail4.htm

 

[dana.oliva]

That is a great idea and how I originally tackled this problem, but it does work for this applicaition. I run into problems when the user needs to modify the text and because it pastes it like a frame in the email it makes for some rather unusual and unexpected problems such as font size, type, bold on; even though you click it off in the menu, invisible text no word wrap it makes my brain want to explode

great suggestion though and I thank you for that!

Dana