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
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
> I'm not sure what you mean. Do you mean 3 different
> databases that you want to merge certain fields of each
[quoted text clipped - 9 lines]
> >make my life easier. Anyone know how to do this?
> >.
Kirt - 08 Oct 2004 18:17 GMT
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
>-----Original Message-----
>Hi Kirt
[quoted text clipped - 24 lines]
>>
>.
Doug Robbins - 09 Oct 2004 01:34 GMT
To see how to do it, see my response to the OP.

Signature
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
>I believe I understand. So you've created 3 separate
> mail merges that have 3 seperate databases each? Where
[quoted text clipped - 43 lines]
>>>
>>.
Doug Robbins - 09 Oct 2004 01:33 GMT
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.

Signature
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
> Hi Kirt
>
[quoted text clipped - 22 lines]
>> >make my life easier. Anyone know how to do this?
>> >.