Email from excel

[cbrd]

I have the following macro assigned to a button. In cell I6, an email address is located. When the button is clicked, it should send the Ranges A1:I88 to the email address in I6.

The macro sends to correct address, fills out the "from" and "subject" correctly, but not the body. If I use .Textbody, every cell comes on a seperate line. If I use .HTMLbody, it eliminates every empty cell or line and everything is bunched together.

What i am trying to achieve, is to have the email body be an exact copy/layout as it is in excel. Anyone have an idea?

Please Login or Register  to view this content.

[royUK]

If you want to use help forums, then share the solutions, even if you found it yourself. Don't just delete the post!

[VBA Noob]

cbrd,

Please read forum rules below and then add the link to the other forum

VBA Noob