Taking out unsubscribed emails by comparing 2 Excel files (Excel 2003)

  • Thread starter Julie - Excel beginner
  • Start date
J

Julie - Excel beginner

Hi everyone

This is my first post. I have hunted in the history, but cannot find
the answer to my question - I hope someone can help.

I have 2 files - one from my CRM system of people I am planning to
email
one from my email marketing system of people who
have unsubscribed

both in Excel 2003.

The common point is email addresses, and I want to look for email
addresses that occur in both lists. These will be unsubscribers and I
don't want to mail them any more.

Can I compare the 2 lists and highlight email addresses that occur in
both, so that I can then delete them from the sending list?

Many thanks for your help! (If you need any help with your electrics,
UK based, let me know!)

Julie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
Emails in Excel format, need to send out a mass email from list 1
Converting excel to PDF, single page converts to multiple HELP! 1
Import data from excel 1
Copy paste emails addresses from excel to outlook? 1
Comparing 2 spreadsheets to remove duplicate names 2
export email addresses of people we have sent emails to to excel 1
Comparing 2 excel files 3

Top