Loop macro based on look up table

[paul_sykes00]

Hi, Hope someone can help with the below,

I have a table of data on sheet 1. Column A is Name. On sheet 2, I then have a second lookup table of data with name and email address.

I am looking for a macro that will filter the sheet 1 table, column A by the first name of the look up table, pdf the screen and email it to the corresponding email address. The macro will continue to do this for all the names on the look up list.

Thanks in advance, Paul