How do I use multiple worksheets when doing a mailmerge

[Donna]

I need to do a mailmerge containing data from 4 worksheets from 1 spreadsheet
document. How do I select all 4 worksheets in order to merge the data?

 

[Doug Robbins - Word MVP]

Word can only use a single, flat datasource for mailmerge. You will have to
add a 5th worksheet to the file on which to bring together in the one place
all of the required information from the other four sheets.

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

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RG9ubmE=?=,

I need to do a mailmerge containing data from 4 worksheets from 1 spreadsheet
document. How do I select all 4 worksheets in order to merge the data?

Since you don't describe any details on how the data is (or might be related)
it's hard to say, but you might see if this article helps

http://support.microsoft.com/default.aspx?scid=kb;en-us;180599

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail