Hi ?B?R3JhaGFt?=,

I have a fairly complex mail merge master that extracts data from an Excell
workbook-That works fine!
With 50+ sheets in the workbook, I need to edit the MM Master with 4 key
items of information prior to completing the mailmerge of each sheet.
I have these 50+ X 4 items of information stored on a separate worksheet.
What is the best method of inserting these four items of key information
into my MMM to save much time, and more importantly avoid error when typing
these in manually?
My knowledge of both the above options is NIL- So please keep it as simple
as possible ?

Based on what you tell us, I'm thinking a LINK field could be what you need.
Copy each of the four sets (cells?) of information for one sheet, go to
Edit/Paste Special in Word; activate "link" and choose "unformatted text".

If that looks pretty much like what you need, press Alt+F9 to look at the LINK
field code. You should see it references the sheetname!r1c1 cell. In Excel,
assign a range name to each cell that clearly identifies what it is
(datasheet1info1, for example). Now substitute the range names for the cell
references in the LINK fields.

When you merge to a different sheet, all you need to do is change the 1 to a 2
for datasheet (for example) for the four Link fields. This can be done quickly
using Find/Replace.

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