Kali

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...RC010390291033

May be something at these sites to give you an idea or two.

Are you running some sort of query on the data?

Are all the names on one sheet? Excel 97 needed the merge data on the first
sheet of the workbook. It had trouble with named ranges.


Gord Dibben Excel MVP


On Fri, 25 Mar 2005 10:51:01 -0800, "Kali Carringer" <Kali
Carringer@discussions.microsoft.com> wrote:

>I have over 200 client names etc to merge into a Word97 doc, but the merge
>only picks up the first 85 clients. How do I get the rest of my clients
>included?