Email Body from Excel cells

[Noxerus]

Sorry to the length of this post but I hope to explain in detail to get the answer I am looking for.

I have a spread sheet that is used to create an email. The problem is that the formatting from excel is not acceptable by some of the audience of the email. So I am looking for a way to build the Email in Outlook from the data that is in the cells of excel. I know that I can pull data from outlook to excel, but I need to do the other direction. Because you can not have text formatting within the same cell I can not format the email the way that it need to be. Below is what I have and what I need.

What I have:

Thursday 7/2:	This is how it works today and
	it continues here.

What I need.

Thursday 7/2: This is the way that this should look when the emails
goes out and the way that they want it to look.

My thinking it if I have a VBA script to pull the data from the cells into the outlook body as just text and then have the script format what I need it would work out correctly.

Thank you anyone for any advise on how I can get this to work out.

[skatonni]

Try something like this.

Please Login or Register  to view this content.