Hi

Be sure that Sheet1 is first one in Master.xls, and that the file is saved
before you continue.
In Word, start Mail Merge and create an empty main document.
Click on Get Data button, select 'Open Data Source', set file type to Excel
files, and locate for Master.xls and open it. Select 'Entire spreadsheet'
when asked.
Continue as usually.
When your mail merge document is ready, start it. In next window you can
select rows to be processed, or set filters on some fields (columns in excel
workbook). A hint here - when you don't have any passing column in
Master.xls, you can add some column into it, which you can use for filtering
in Mail mMerge afterwards.

To use excel worksheet as mail merge source, all data MUST be in one single
continous table. The table MUST have a header row. All data for one mail
letter/envelope/label MUST be on single row. It's easier when the table is
on leftmost tab of workbook, but there are ways to make it work otherwise
too (using named range).


Arvi Laanemets


"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