View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Can I merge two data sources (mailmerge) ie. 2006 + 2007

Use copy and paste. Or if the data files are not identical, use a catalog
or directory type mail merge on each of them to produce a document
containing the identical information for each one and the copy and paste
those together

To do this, create a catalog (or in Word XP and later it is called
"directory") mail merge main document in which you have a one row table into
the cells of which you insert the field names. There must be nothing else
in the document. Then merge this mail merge main document against each of
the data sources in turn (changing any field names as necessary, but doing
that so that the similar data appears in the same columns) to the only
possible destination which is a new document.

Then you will get a document for each data source, each of which contains a
table with one row of data for each record in the data source. Copy one of
these tables and paste it under the other and then remove the paragraph mark
that separates them so that you end up with one table. Then insert a row at
the top of the table and into the cells of that row, insert field names.
Then save that document as the data source to be used.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"smeagle2007" wrote in message
news
I have annual customer data files in my "data sources" file. I would like
to
merge the data together without having to retype each individual entry
into
the existing data source. Is there a way of quickly merging the data
sources
together to create one expanded data source with both lots of data?