Can I use more than 1 worksheet to merge info

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kimmer - 29 Aug 2006 03:27 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 29 Aug 2006 04:34 GMT

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.

Signature

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

>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?

Reply to this Message