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?

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" <(E-Mail Removed)> wrote in message
news:5606BB82-1853-4CD5-9D66-(E-Mail Removed)...
> 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?

For the label format list - see
http://www.gmayor.com/convert_labels...mail_merge.htm
Then for both lists see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm which cover the
genereal principles of mail merge.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Gabe wrote:
> 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?