Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Gabe Gabe is offline
external usenet poster
 
Posts: 8
Default Auto fill-in text and importing information

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?
  #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?


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Auto fill-in text and importing information

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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
auto-fill the next 3 fields when selecting text from a dropdown Freddie Fredricks Microsoft Word Help 5 September 25th 07 06:25 AM
Importing information from excel to word [email protected] Mailmerge 3 August 3rd 07 04:37 PM
Importing information from contacts to word pbscott Microsoft Word Help 8 September 7th 06 10:25 PM
Importing reference/bibliography information Clement Chau Microsoft Word Help 1 August 1st 06 03:31 PM
How do I auto fill a text field? lauren Microsoft Word Help 1 July 27th 05 09:41 PM


All times are GMT +1. The time now is 01:08 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"