LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Taking out unsubscribed emails by comparing 2 Excel files (Excel 2003)

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing 2 excel files AB@ Excel Discussion (Misc queries) 3 May 3rd 07 03:53 PM
Comparing 2 excel files AB@ Excel Discussion (Misc queries) 0 May 3rd 07 11:58 AM
comparing excel 2003 and excel 2007 tjccs4 Excel Discussion (Misc queries) 4 February 12th 07 02:06 PM
how to stop emails incoming its taking a long time to download emails incoming New Users to Excel 1 June 25th 06 03:24 AM
Comparing a value in EXCEL and XML files Vishnu Excel Discussion (Misc queries) 0 October 23rd 05 06:43 PM


All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"