I have two different mailing lists, one from company A and one from
company B. To prevent company A & B from sending duplicate
invitations, I would like to combine the two lists in Access using e-
mail addresses as a unique identifier. How do I query to find and
separate the duplicates into a separate table. The desired end result
would be one final mailing list (the duplicates identified and Company
A's mailing information kept) and one list with all the duplicate
contacts?
If you create a new query, the query wizard can create a
find duplicates query for you.
Re: Stop Outlook from sending multiple copies of same message ... You have confirmed that there are no duplicate records produces by the SQL statement by running it as a standalone query.... I would advise your receipients that if they have multiple email addresses to send you ALL of them and to indicate which one is their preferred email. ... You may want to add Debug.Print varBCC right before you call sendMail to snoop wether or not duplicates exist there, although I don't believe that they will. ...lists.... (microsoft.public.access.modulesdaovba)
Re: Merge two or more tables into new table ... and then you could use that to set the SQL of a query.... UNTESTED AIR CODE for building the SQL String; You can use the string to build ... Our lists are extracts from our exchange server, ... To the human they are duplicates, to the computer they are not. ... (microsoft.public.access.queries)
Re: Stop Outlook from sending multiple copies of same message ... You have confirmed that there are no duplicate records produces by the SQL statement by running it as a standalone query.... I would advise your receipients that if they have multiple email addresses to send you ALL of them and to indicate which one is their preferred email. ... You may want to add Debug.Print varBCC right before you call sendMail to snoop wether or not duplicates exist there, although I don't believe that they will. ... The VBA code works without sending multiple copies on other lists.... (microsoft.public.access.modulesdaovba)
Re: removing dupliates from 2 lists with similar content ... In XL2007 there is a feature to Remove Duplicates under the Data tab. ... sheet that others can just drop their lists into? ... Each contains unique entries, as well as ... (microsoft.public.excel.newusers)
Re: Impl of a list of key/value pairs (and more ?) ... i.e. some kind of 2-dimensional array of keys/values or objects... ... As you can see it may contain duplicates (on either side of the ... handled by having Lists of integers as the values in the first place. ... insert(test, "abc", 10); ... (comp.lang.java.programmer)
