Excel VBA outlook - Range in mail body

[[email protected]]

Hi,

I am trying to send email (outlook) through excel VBA code. I am able to send mail with attachment using following code But I want to put range of cells in message body with format. I have a piviot in the excel which i want to copy in mail body.

Please help!

Please Login or Register  to view this content.

[jaslake]

Check out this link for examples of how to mail a range in the Email Body

http://www.rondebruin.nl/win/s1/outlook/mail.htm

[[email protected]]

Thanks for your quick reply. Sorry, it did achieve what i wanted.

I tried below code taken from the link you have provided. It copies range of cells and copies to another sheet sends as attachment. What i am looking for is those range of cells to be copied to mail body.

In below example, my mail body is "Hi there" which i do not want. Instead of this, i want range of cells to be copied. Please help!

Please Login or Register  to view this content.

[jaslake]

Hi dphadke-gmail-com

Please wrap your Code in Code Tags.

Go to the Referenced Link and scroll down to the Outlook object model (body) section

Capture.jpg

[arlu1201]

dphadke,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.