How to subtract list A from B for new names?

So Cal · Joined: 01 Oct 2007 Posts: 6

Need your help please. I have two lists:

List A: old address that have been used once.

List B: new and larger, but contains some names from List A.

How do I subtract List A from List B, netting a new List C? Can I do it with eMail Extractor, another program, or do I have to do it manually?

Thanks in advance.

-Rob

stanbusk · Site Admin Joined: 28 Dec 2005 Posts: 2122

Yes, drop both lists to eMail Extractor. Output file never contains duplicates.

So Cal · Joined: 01 Oct 2007 Posts: 6

Stanbusk, thanks, but that's not what I am trying to do.

Running A+B = C is easy with eMail Extractor (automatically removing duplicate names at the same time).

I want B-A = C. In other words, I want to subtract small "used" List A from a larger "new" List B. The resulting List C has unused names.

Presently I do this manually using Excel:
- the new larger List B goes in the first column
- the old List A goes in the second column
- the second column's text is turned red, then cut to the clipboard
- the red text is pasted into the first column
- the new list in the first column is put in alphabetical order
- manually search-and-delete all red names, and preceding duplicates

The result is a new list "sanitized" of any names previously used. It takes time to do, so it works for small- or maybe moderate-sized lists only.

Thoughts?

stanbusk · Site Admin Joined: 28 Dec 2005 Posts: 2122

Ok. You have to use MaxBulk Mailer. Load list B, rename list A as 'DELETE and drop it over list A. MaxBulk Mailer will then remove all addresses of list A from list B.

So Cal · Joined: 01 Oct 2007 Posts: 6

Okay, got it. Thank you for your answer.