Thread: Checking duplicate emails in Excel and Outlook 2007

Hi,

I have a list of email addresses in Excel 2007 spreadsheet. Please see the attached file.

I would like a Macro code which will allow me to check if duplicate emails have (already) been sent in Outlook 2007 from the list of entries in the spreadsheet (Rows G to R). There are over 1000 records in Excel 2007.

When the "Check duplicate emails in Outlook" button is pressed the list of emails should be checked against Outlook 2007. If there are any duplicate emails they should be listed (names and emails) within the "Dups" tab in Excel 2007.

The user should have the ability to "select" the rows in spreadsheet as desired and only the "selected" rows/emails should be checked in Outlook 2007.

Can anyone assist please?

TIA
Ash