Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to use an excel list of names in Word (that does not appear in table)?
I need to be able to convert names listed in an excel file (a few
columns eg. Mr Joe Bloggs)into a Word document. I then want to be able to insert sub headings etc. For example in excel: A1 B1 C1 Mr Joe Bloggs Mrs Mary James Mr John kelly Mr Henry Morris Mr Mike Smith Miss Stacey Timpleton Mr Jimmy Young I want to cut and paste it into Word to look similar but no cells separating each word Then create a list and insert sub headings within it: Sublist A Mr Joe Bloggs Mrs Mary James Mr John kelly Sublist B Mr Henry Morris Mr Mike Smith Sublist C Miss Stacey Timpleton Mr Jimmy Young This list of names will need to be cut and pasted regularly from Excel into Word. Any tips appreciated. Colin |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to use an excel list of names in Word (that does not appear in table)?
Use the 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. wrote in message oups.com... I need to be able to convert names listed in an excel file (a few columns eg. Mr Joe Bloggs)into a Word document. I then want to be able to insert sub headings etc. For example in excel: A1 B1 C1 Mr Joe Bloggs Mrs Mary James Mr John kelly Mr Henry Morris Mr Mike Smith Miss Stacey Timpleton Mr Jimmy Young I want to cut and paste it into Word to look similar but no cells separating each word Then create a list and insert sub headings within it: Sublist A Mr Joe Bloggs Mrs Mary James Mr John kelly Sublist B Mr Henry Morris Mr Mike Smith Sublist C Miss Stacey Timpleton Mr Jimmy Young This list of names will need to be cut and pasted regularly from Excel into Word. Any tips appreciated. Colin |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to use an excel list of names in Word (that does not appear in table)?
Thank you Suzanne. I have tried this but after selecting insert merge
field' in Word only the first name on my database column is moved across. When I insert the same code repeatedly so that the next name the column is inserted below it won't do this. How do I get it to create a list from my column of names? Many thanks Colin Suzanne S. Barnhill wrote: Use the 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. wrote in message oups.com... I need to be able to convert names listed in an excel file (a few columns eg. Mr Joe Bloggs)into a Word document. I then want to be able to insert sub headings etc. For example in excel: A1 B1 C1 Mr Joe Bloggs Mrs Mary James Mr John kelly Mr Henry Morris Mr Mike Smith Miss Stacey Timpleton Mr Jimmy Young I want to cut and paste it into Word to look similar but no cells separating each word Then create a list and insert sub headings within it: Sublist A Mr Joe Bloggs Mrs Mary James Mr John kelly Sublist B Mr Henry Morris Mr Mike Smith Sublist C Miss Stacey Timpleton Mr Jimmy Young This list of names will need to be cut and pasted regularly from Excel into Word. Any tips appreciated. Colin |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to use an excel list of names in Word (that does not appear in table)?
Insert the merge fields once, then press Enter. Make sure that the merge is
set up as a Catalog or Directory merge. After you have created the mail merge main document, you must merge to a new document to get the list. -- 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. wrote in message ps.com... Thank you Suzanne. I have tried this but after selecting insert merge field' in Word only the first name on my database column is moved across. When I insert the same code repeatedly so that the next name the column is inserted below it won't do this. How do I get it to create a list from my column of names? Many thanks Colin Suzanne S. Barnhill wrote: Use the 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. wrote in message oups.com... I need to be able to convert names listed in an excel file (a few columns eg. Mr Joe Bloggs)into a Word document. I then want to be able to insert sub headings etc. For example in excel: A1 B1 C1 Mr Joe Bloggs Mrs Mary James Mr John kelly Mr Henry Morris Mr Mike Smith Miss Stacey Timpleton Mr Jimmy Young I want to cut and paste it into Word to look similar but no cells separating each word Then create a list and insert sub headings within it: Sublist A Mr Joe Bloggs Mrs Mary James Mr John kelly Sublist B Mr Henry Morris Mr Mike Smith Sublist C Miss Stacey Timpleton Mr Jimmy Young This list of names will need to be cut and pasted regularly from Excel into Word. Any tips appreciated. Colin |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Inserting Excel tables into Word | Microsoft Word Help | |||
Open with... does not include Word | Microsoft Word Help | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables |