Send multiple PDFs in a folder to email addresses within a sheet from one of your email accounts in outlook

[fjorr]

Hi there,

I need to send multiple PDFs from payment folders to email addresses within an excel file.

I have a macro set up to pdf all the individual sheets into PDFs, and I have a sheet set up with all the email addresses in column A and the destination path in column B. In addition to this my outlook has 3 accounts so I need to send them through using one specific account.

Any help would be amazing,

Thank you