Modification in the Excel to Outlook mail

Prabhu

New member
Joined
Nov 5, 2013
Messages
8
Reaction score
0
Points
0
Hi All,

I am using the attached macro to send excel sheet thru outlook mail body and am facing problem when the sheet is not exist.

In the attached macro "Sheet 9" send to Mr.SSS(efgh@gmail.com) is not available but it is pasting the previously copied "Sheet1" instead of not coping(should be blank).

Kindly help to modify if the sheet is not exist it should not copy anything.

Regards,

Prabhu
 

Attachments

  • Copy to body of the mail (1) (1).xlsm
    38.5 KB · Views: 7
Top