Send email to specific group of email ids and their respective attachments using VBA

[nishalmenezes]

Hi All,

Need help to sort out this issue.

I have a group of Email IDS and their Names in the respective column in a excel sheet.

Secondly there are excel attachments in one specified folder on desktop and these attachments file names are exactly the same as the names mentioned in the excel sheet with email id'.

Need a macro which sends email automatically to the specified email id' with the respective attachment for that particular email and name mentioned in it.

Example:
nishalmenezes@gmail.com Nishal Menezes nishalmenezes.xlsx

Please share some thoughts to solve this.

Regards,
Nishal M