Hi Kaimwatie,
I have an Excel document with the same default info in
the first row (ex. First, Last, Address) and wish to know
if I can merge the data from many sheets in the same
workbook to the same letter.
No, you can't. At least, not directly. Word can only link a
single sheet / merge.
Using MS Query you can set up a UNION query to do this.
Unfortunately, I don't have time to type up all the
instructions for this, as I'm leaving in a couple of hours.
But I think Peter Jamieson posted the basic way to build a
Union query within the last couple of weeks. Do a Google
search on this group for "Union query" and you should turn
it up.
Armed with this, you should be able to go to an Excel
newsgroup and ask about MS Query, if you need help with it.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
