Send individualized PDF to each recipient from a list

[Dollismine]

Hello All,

I use a macro that generates a PDF summary of sales made by each seller.
Then, I send each individual PDF to each seller. I do it manually.

I would like to modify the current macro (or create another one if easier) to automatize the sending process.
Each individual PDF should be sent to the good recipient, via CDO (Outlook in 2nd choice if it's not possible via CDO)

For example :
PDFJohn to john@...
PDFClaire to claire@...
etc ect...

Unfortunately, my VBA skill is very limited and I don't find the solution myself
Is someone could help me ?


https://sendeyo.com/show/26fe7ed083

Thanks all !

 

[Dollismine]

Nobody ?