Code to covert different excel sheet to pdf and send to different recipents

[cutelebel]

I need a code to convert different excel files into pdf and send to different recipients. will appreciate any assistance

[k64]

You could use a mail merge in word. Also, you can use this code to save as pdf

Please Login or Register  to view this content.

You can use the code from this post to send emails
Help required to send email as per the inputs in the cell

[cutelebel]

hello k64...thanks for your response please find attached copy of my workbook since the code is not working as expected

[k64]

The save as pdf works for me. As for sending via email, like I said, I know you could do it via mail merge through word. Otherwise, the thread I mentioned has someone trying to do the same thing. It looks like it's still in progress, but I expect that when he gets his answer, you could use the same code.