How do you merge several mailmerge lists together?

  • Thread starter That Names Taken
  • Start date
T

That Names Taken

I have three separate lists (in Word 2002) and want to merge them together to
make my life easier. Anyone know how to do this?
 
K

Kirt

I'm not sure what you mean. Do you mean 3 different
databases that you want to merge certain fields of each
into one mail merge letter?

If so I suggest merging all 3 databases into one like
Excel spreadsheet and using that one only.
www.dreamforce.us
 
T

That_Names_Taken

Hi Kirt

I have three separate database lists using mailmerge wizard and I want them
all merged into ONE mailmerge database wizard that I can use.

At the time they were needed separately - now they're needed in one.

Does this make more sense?

Thanks,
TNT
 
K

Kirt

I believe I understand. So you've created 3 separate
mail merges that have 3 seperate databases each? Where
is the data contained, in Access or Excel (in Word 2000
you could use Word's Tables)? If you can find out which
program was used to create all 3 databases that would be
the first start. The default place Word saves is in "My
Data Sources" folder as an Access File or .mdb extension.

Once you find the 3 databases you'll want to import them
all into one and use that for your mail merge. I hope I
answered your question, but if I misunderstood then
please let me know.
www.dreamforce.us
 
D

Doug Robbins

Set up a Directory type mailmerge main document with the mergefields in the
cells of a single row table. Execute that merge against each of the data
sources which will give you three documents, each of which contains a table
with all of the records in it. Copy and paste the tables from two of the
documents into the third and, if necessary, remove the paragraph mark
between each of the tables so that they join into one. Then insert a row
and the head of the table into the cells in that row, enter the names of the
mergefields. Then save that document and use it as your datasource.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 
D

Doug Robbins

To see how to do it, see my response to the OP.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top