multiple worksheets mail merge

[Jamie]

I was given a workbook with 5 worksheets of addresses to
print mailing labels. I'm able to do a mail merge from
Word with 2 of the worksheets only. I'm using Windows XP
and Office 2003. Is there possibly a setting in Excel
that's prohibiting me from merging the other 3
worksheets? Thanks for the help, -Jamie

 

[Gord Dibben]

Jamie

Check out the info here on creating the data source for a mail merge.

http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

Specifically "using Excel" and note the different methods......DDE or ODBC

Use ODBC for multiple ranges.

More info at......

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

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

Gord Dibben Excel MVP