Use Vlookup to loop through and find each email address before sending

Hi,

Currently, in the code below, it's only looping through and getting the names. Instead of getting the names I would like it to find the email address of each entry in columns I and J by vlookup to the sheet that contains the email addresses ("Email List") Worksheet.

Please Login or Register  to view this content.

You have not indicated what sheets you are referring to and your code does not match the example that you attached.