Merge two Mail Merge list.

  • Thread starter Thread starter Guest
  • Start date Start date
Hi

You could just copy all the records in 1 and paste append them into 2.

Would need more information about what you're trying to do and if you see
and problems - i.e. are there duplicate records, different formats,
incomplete address's, etc, etc.
 
The usual way to "merge" two sets of data is through a union query.

As Wayne says, it depends on the source of your data.

1. If you have a single set of addresses, but have two queries that
generate separate recordsets for that data based on different criteria, then
you could just modify the WHERE clause of your query to contain both
conditions.

2. another way to do this is to use a UNION query. The Union query (only
available in the SQL view) allows you to conbine the contents of two
datasets, as long as the fields are of the same data type. Additionally, the
Union query also deletes duplicates from the merged data set, so you don't
get two identical records. This query might look like:

Select AddName, AddNum, AddStreet, AddSuffix, AddCity, AddState, AddZip
FROM query1
UNION
Select AddName, AddNum, AddStreet, AddSuffix, AddCity, AddState, AddZip
FROM query2

If you use "UNION ALL" rather than "UNION" in the query, it will return all
of the records from query1 and all of the records from query2, and may
include duplicates.

HTH
Dale
 
That worked. The only thing I was wondering now, is how to prevent
duplication? I am working on a huge mailing, and have say three or more
list's going on. Well now my boss just wants everything into one list, and
just have me flag everything. All of these list kind of work together.

Thanks
 
Back
Top