How do I use multiple worksheets when doing a mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna - 02 Feb 2006 15:31 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 02 Feb 2006 15:57 GMT

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.

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

Reply to this Message

Cindy M -WordMVP- - 02 Feb 2006 17:10 GMT

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

Reply to this Message