Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto-fill the next 3 fields when selecting text from a dropdown | Microsoft Word Help | |||
Importing information from excel to word | Mailmerge | |||
Importing information from contacts to word | Microsoft Word Help | |||
Importing reference/bibliography information | Microsoft Word Help | |||
How do I auto fill a text field? | Microsoft Word Help |