Can I use more than 1 worksheet to merge info

[kimmer]

I have a large Excel 2003 file with multiple worksheets. I want to create a
letter in Word 2003 that merges information from several of the worksheets.
Can that be done?

 

[Doug Robbins - Word MVP]

No, Word can only use a single, flat data source for a mail merge. You
will need to combine all of the required information onto one sheet in the
Excel work book.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP