Send Email 1 sheet as attachment and other sheet as body of emial.

Hello Again,

I have been searching for vba macros to send one worksheet as attachment and other worksheet as message of email but fail to find it. Can any one help me to get this script.

What i need here is i have one workbook with 2 worksheets. I need to send one worksheet at attachment with cell value as file name and other worksheet as message in the email.

Sample file is attached for your reference.

Any help is highly appreciable.

i am trying to send an email using excel VBA Macros. I want to send 1 sheet as an attachment and other sheet range as body of message. Can any one help me please.

Thanks john for your reply but i have one question can be the range as A1:I40 something like this instead of below

Please Login or Register  to view this content.

Something like below

Please Login or Register  to view this content.

i am writing like this but it is not showing on the body of email any help on this issue

Thanks for your response John, It works on my original file. Sorry for delay in replying.

Topy marked as solved and reputation added.