Hi -

I've had a look through the posts but can't seem to get my head around this one.

I have a list of email addresses which are assigned to email lists.

PK EmailID, ListID EmailAddress

I want to create a new list from two existing lists, without duplicates.

The only way I can think of doing it right now, is to create the new list, add all the emailaddresses from list 1. Going through list 2 , try and load an email address using a filter to make sure it's not there, then add it.

Must be an easier way.... Can you help?

Phil.

Phil wrote:

Hi -

I've had a look through the posts but can't seem to get my head around this one.

I have a list of email addresses which are assigned to email lists.

PK EmailID, ListID EmailAddress

I want to create a new list from two existing lists, without duplicates.

The only way I can think of doing it right now, is to create the new list, add all the emailaddresses from list 1. Going through list 2 , try and load an email address using a filter to make sure it's not there, then add it.

Must be an easier way.... Can you help?

Phil.

Sure First select all email addresses belonging to list 1, with the filter that they aren't on list 2. Then add list 2