Merging data from multiple sheets in one excel file?

[Kath]

1. How do you pick and choose which sheet of information
is wanted for the mail merge function?

2. Is it possible to have data on multiple sheets and
mail merge all into the letter?

Thanks a bunch!

Kath

 

[Doug Robbins]

If under Tools>Options>General in Word, you check the box against the
"Confirm conversion at Open" item, when you connect to the datasource, you
will be given a number of options of the way to connect, one of which will
give you the option of choosing which sheet to use - I forget which one it
is.

Word however can only use a "flat file" as a datasource, therefore you will
have to create a single sheet that references the cells on the other sheets
to be able to get it all used in a mailmerge.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP