***Excel to Outlook mail body—Modification Required***

Hi All,

I have attached a macro which is helping me to copy the excel sheet to outlook mail body.

my Query is if the mentioned sheet is not available in the workbook, it is pasting the previously copied sheet.

Example in the attached sheet there are two set of mails can be sent, Mail to Mr.RRR is having all the sheet(Sheet 1 & Sheet2) but Mail to Mr.SSS is not having Sheet 9 but the macro is coping sheet1.

I need a modification if the given sheet is not available then the message to be pasted like" No Sheet9" instead of pasting sheet1 and it should continue to run(if i want to add some more mails)

Kindly help to modify the attached sheet.

Regards,

Prabhu

Hi nathansav ,

I tried to amend the code but i am getting error.

Could you help me to amend code in the attached Sheet