Email a converted worksheet as pdf to addresses in a range of cells

I have found and copied the vba code to convert and email a worksheet as a pdf file but want to to send the file to email addresses within a range of cells within that worksheet. for example
A1 [email protected]
A2 [email protected]
A3 [email protected]

I currently use this to send the worksheet without converting to pdf from Ron De Bruin's website.

Please Login or Register  to view this content.

this is the part of the code to send excel worksheet as pdf file.

Please Login or Register  to view this content.

hope this makes sense.