Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Can I merge two data sources (mailmerge) ie. 2006 + 2007
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data sources for different mailmerge letters | Mailmerge | |||
Mail Merge using two different data sources. | Mailmerge | |||
data and header sources in mail merge | Mailmerge | |||
Can I mail merge using two or more data sources | Microsoft Word Help | |||
MailMerge Data Sources | Mailmerge |