Insert > Field control in Word; Link to Excel Sheet

[ryguy7272]

Is anyone here familiar with the Insert > Field control in Word. I believe
there is a way to link Word to a range in Excel (in my case Column C). I’m
trying to help my supervisor link some form letters that we have, to the data
in Column C (which contains identification numbers), in an Excel worksheet.
We’ve done mail merge, and it works great, and I’m thinking there is probably
a way to identify the appropriate ID number in Column C, and mail merge all
relevant info. into the contact fields. Does anyone have an idea of how to
do this?

Cordially,
Ryan---

 

[Bill Renaud]

In Word, bring up the "Insert Field" dialog box, select "Links and
References" in the "Categories" list box on the left, then select "Link"
in the "Field names" list box on the right.

See the "Field codes: Link field" Help topic in Word for syntax details.

I haven't actually used this feature, so can't give more explicit
advice.

 

[Bill Renaud]

What do you mean by "... identify the appropriate ID number in Column C,
and mail merge all
relevant info. into the contact fields"?

It sounds like the standard Mail Merge tool might do the job, but
without more understanding of what your form letter looks like, it is
hard to know. Is your data in Excel in a simple list (column labels on
row 1)?

 

[ryguy7272]

I got it, with tons of help from Doug:
http://www.microsoft.com/office/com...a871f274425&cat=&lang=en&cr=US&sloc=en-us&p=1

Thanks!!
Ryan---