Need help in editing the current Macro to send email with multiple attachments frm Outlook

Hello Guys,

I am using a below attached Macro file as a “database” to send an email with more than one attachment.

The Macro is look for the File names in Column A and B and pick the same files from the user defined location and attached them in new email.

Problem is, if there no file is found with name mentioned in both Columns A and B; still an email is getting sent by outlook without any attachment.

Can anyone help in editing the Macro to do not create an e-mail if both files mentioned in Column A and B are not found at whatever the user defined location.

Note: Only a sample file is attached for your reference.

Thanks,
Manish_Gupta

Try this...

Please Login or Register  to view this content.

Please Login or Register  to view this content.