VBA to look for duplicates in two rows and skip

Hi,

I'm using the code below to send customized emails to employees who are profiled to occupy workspace in more than one building. We occasionally receive responses with a justifiable explanation as to why that is. I would like to enter the email addresses of these employees onto an "Exclusion Column" and insert a VBA command to search Range "P" for an identical entry in an exclusion list column "Range AQ" to skip these employees when generating the Outlook emails.

Any help would be much appreciated. Thanks!

Please Login or Register  to view this content.