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