View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Auto fill-in text and importing information

What you are describing is a mail merge, and yes, you can use an Excel sheet
as a mail merge data source. See
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Gabe" wrote in message
...
I have a large list of people in excel (about 200 people) and a large word
list that is in label format (again, about 200 other people). What I want

to
do is send a form letter to all of these people (alumni of my

organization).
I want to know if I can set a certain selection of text to auto fill from

the
cells in excel. For example, I have the first name in box a (in excel)

and
last name in box b (in excel). I would like to fill in the name line in

word
to fill in with box a and b from excel. So on and so fourth including
address and title. Is this possible at all?