Hi Dean,
I searched for this on the forum before submitting this and found no threads... so here goes...
In the "Edit Selections" options it says, "The Filter Duplicate Email Addresses option prevents duplicate email addresses from showing up in the result, which is useful when mailing multiple lists."
My question is, HOW do the duplicate emails get filtered when combining lists? In other words what the's filtering process/criteria? Is it based on the time stamp of when a subscriber came into that list (the earlier one stays, the older one gets removed), etc?
My problem is I have several lists, but the customer input into the fields are different in each list, even though the custom field 'name' was the same. So if I was to do a mail merge with the customer fields I want included, which customer field would show up once the "Filter Duplicate Email Addresses" selection was made to mutiple lists?
For example, I have 2 lists.
List 1 data fields are:
fname,lname,email,birthdate,product
List 2 data fields are the same:
fname,lname,email,birthdate,product
As you can see, the fields are the same, but the output would be different if they had purchased a diffferent "product" using custom fields.
So, if the SAME person was on list #1 AND list #2, and I did a filter to remove duplicate addresses and THEN I used a code function for my custom field in the email, which is "!product" - BUT they bought 2 different products, eg. "My Product 1" and "My Product 2"... if I merge the 2 lists together and want to include the !product code in the email to reference the product they bought, which one of the products will actually show up in their email?
I hope that's clear :-)
-Dave
