VBA Code to select Range of cells as Email Body In Outlook

**naveenmarapaka** · 09-22-2012, 07:13 AM

Hi dears i have done a small VBA Code to send the current file as attachment through Outlook.

file is successfully attached and mail is been sent.

But my problem is i am unable to fill Body in Mail.

please find attached i want to select range A1:D18 in sheet (Table) as BODY to my Email.

code i mentioned below is not working. pls help

' .body = ActiveWorkbook.Sheets("Table").Range("A5")
.body = ActiveWorkbook.Sheets("Table").Range("A1:D18")

Please Login or Register  to view this content.

**BuckoAk** · 09-23-2012, 07:04 AM

The additional code will do what your looking for, give it a try.

**naveenmarapaka** · 09-23-2012, 10:02 AM

Dear Buck its working good now, thanks for your help

**TC922** · 09-16-2013, 06:19 AM

I am having a similar issue I am trying to send the info from cells A1:G38 as the body of my email.

I need two options to send the same data one for a day shift one for a night shift as the subject line will change but the format will not. My code sends the email just that the body of the email is always blank? any ideas? Also when I add the second function (Night shift) the macro doesn't run. Thank you in advance.
PLC Shift report.xlsm

**arlu1201** · 09-16-2013, 06:32 AM

TC922,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.