Link field PlaceReference using a Range Name

[Peter McNaughton]

Hi,
I want to bring some excel cells into a mailmerge document but am
failing with the syntax for the RangeName. What I would like is a
general example for a LINK field

Workbook = BOOK1.XLS
Sheet with Range Names = Sheet1
I have 3 RangeNames: RN_100, RN_200, RN_300

The Link field should look "something" like this
{LINK Excel.Sheet.8 "C:\\Book1.xls" "RN_100" \b}

I can get something when I use RC notation
{LINK Excel.Sheet.8 "C:\\Book1.xls" "Sheet1!R1C1:R10C5" \b}

I have a 2nd related question

How should I tackle a mailmerge to use the 3 range names.
I merge from a file MERGEFROM.XLS
Range Name Address ...
RN_100 Peter 1 Any Street
RN_200 Paul 33a Small St
RN_300 Mary 75 Highsted Rd

I assume that there will be a nested IF statement in association with
the {LINK...} statement?

Can anyone point me in the right direction

Thanks in advance

Peter
I have found a few postings that point back to the help.

 

[Peter Jamieson]

The Link field should look "something" like this

{LINK Excel.Sheet.8 "C:\\Book1.xls" "RN_100" \b}

Adding the Sheet name should do the trick:

{ LINK Excel.Sheet.8 "C:\\Book1.xls" "Sheet1!RN_100" \b }

How should I tackle a mailmerge to use the 3 range names.
I merge from a file MERGEFROM.XLS
Range Name Address ...
RN_100 Peter 1 Any Street
RN_200 Paul 33a Small St
RN_300 Mary 75 Highsted Rd

I assume that there will be a nested IF statement in association with
the {LINK...} statement?

Not necessarily. If I have understod correctly, you could use e.g.

{ LINK Excel.Sheet.8 "C:\\Book1.xls" "Sheet1!{ MERGEFIELD Range }" \b }

What you will probably see is that in the Mail merge main document, you will
get an "Error! Not a valid link" message. If you merge to a new document,
you will see the same thing, but if you then select the entire output
document and press F9 you should see the links correctly updated.

However IME Word has a nasty habit of re-interpreting LINK fields in various
ways, and probably in different ways in different versions (I used Word 2000
to check this stuff FWIW). You may also find that this technique only works
when you use certain connection type sin your mail merge main document.

 

[Peter McNaughton]

Thanks
The instructions were fine BUT I could not get it to work with Word
and Excel 2002. Will try my luck with Excel 2000 but would like to
get 2002 to work.

Peter

 

[Peter McNaughton]

Thank Peter
I finally got it to work with Word/Excel2000. The eureka moment came
when I read another google post that said CTRL F9 gives the {}
brackets. It all became so much easier after that. Even the
MERGEFIELD WORKS.