Hi

Somehow we aren't able to communicate or what ...
1. Make necessary entries in Master.xls. Add a column Selected into source
table, and enter p.e. "X" for all records yuo want to be processed. Save the
file.
2. Open predesigned mail merge main document in word, or create a new main
document with Master.xls as source table.
3. Select Mail Merge from menu (again), and
3.1. Press Query Options. Set filter to Selected="X". Close Options window
and continue with mail merge - your 20+ documents are
printed/mailed/faxed/created - as you select in next window.
3.2. Press Merge. In Merge window, press Query Options. Set filter to
Selected="X". Close Options window and continue with mail merge - your 20+
documents are printed/mailed/faxed/created - as you select in Merge window.
When you create a new document, a N*M -page word document is created, where
n is number of processed records, and m is number of pages for one document
matching for single row in source file.

From where do you get those 20+ merge files to open?

When you add records into your Excel table after you opened MM main
document, and want to process them, then it isn't enough to save the source
file - you have to relink the workbook to main document anew (pressing Get
Data button, etc.).


Arvi Laanemets


"Rashid Khan" wrote in message
...
Hello Gord and Arvi,
Thanks for the prompt reply.
I am aware how to create the mail merge. What I was after that while the
Master.xls is open is there a possible way to conduct the mail merge...
becoz now I am going thru the following steps
Step 1) make necessary entries in master.xls.. and ofcourse save it.
Step 2) Go to MS Word and Open 20+ different mail merge files to generate
the required letters.

Is there some way of automating this whole process.

Any clue?
Rashid
"Rashid Khan" wrote in message
...
Hello All,
I am using Office 2000 and have a workbook named Master.xls with Sheet1
having 100+ columns of data running several hundred rows down.

A1, B1, C1....... are headers like Name, LastName, Address1,
Address2............and so on

I want to use Master.xls for generating about 20+ mail merge letters in
MS
Word. I have designed the Mail Merge file in Word with all the required
fields...

I wish to know how is it possible for me to generate the Mail Merge
letters
in MS Word while I am working on the Master.xls file.

1) Do I need to close the Master.xls file and then generate each and
every
letter in Word?
2) Do I need to make 20 odd Command Buttons in Master.xls and by
clicking
the appropriate button the corresponding Mail Merge letter will be
generated
(I am not sure whether this is possible while Master.xls is open!)
3) Do I need to extract the relevant data from Master.xls file to 20+
different Worksheet and then create Mail Merge accordingly..
I am totally confused how to go about this problem.

Any suggestions, lead in this matter would be greatly appreciated.

TIA

Rashid