Insert Field control in Word; Link to Excel Sheet
 

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). Im
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.
Weve done mail merge, and it works great, and Im 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---

--
RyGuy

Insert Field control in Word; Link to Excel Sheet
 

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.

--
Regards,
Bill Renaud

Insert Field control in Word; Link to Excel Sheet
 

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)?
--
Regards,
Bill Renaud

Insert Field control in Word; Link to Excel Sheet
 

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

Thanks!!
Ryan---



--
RyGuy


"Bill Renaud" wrote:

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)?
--
Regards,
Bill Renaud