Macro to send individual files via mail merge

Hello Community,

I have a folder with 2000 odd individual pdf files for my employees in my company.

I am trying to seek your expert help in creating a macro which will help me assign the correct pdf file and send it to an email assigned against each filename.

I have the employee number, PAN No (primary file name), and an email ID against each employee number.

Looking forward to your help in this.

Thanks,
Pratap

attached your workbook with sample data

I agree a workbook needs to be attached.

Other questions
Are the PDFs generated from the spreadsheet or existing files
Do the PDFs exist in the same folder
If PDFs exist, what is the matching criteria?

There are many website giving all or half of the solution

YOu need to loop through the emails within the excel sheet, match with the PDF and send to the email. But with no file it is hard to be more specific

There are many website giving all or half of the solution

https://stackoverflow.com/questions/...sing-excel-vba
https://www.contextures.com/excelemailpdf.html