Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Transfer Names from Excel to labels in Words
I have a list of names and addresses of clients written in Execel
horizontally. I would like to print the names and addresses out on labels in Word. Does anyone know how to trasfer the info to labels to be printed? Monica |
#2
Posted to microsoft.public.word.pagelayout
|
|||
|
|||
Transfer Names from Excel to labels in Words
I am not quite sure what you mean by horizontally, but if you mean that you
have the names in the columns in Row 1 and the addresses in Row 2 or Rows 2 and subsequent rows, you can use CopyPaste SpecialTranspose in Excel to get them into a vertical arrangement so that you can use them as a mail merge data source. See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm See the article "Mail Merge with Word 2007" on fellow MVP Graham Mayor's website at http://www.gmayor.com/merge_labels_with_word_2007.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "mh" wrote in message ... I have a list of names and addresses of clients written in Execel horizontally. I would like to print the names and addresses out on labels in Word. Does anyone know how to trasfer the info to labels to be printed? Monica |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer Excel database to Microsoft Word - print labels? | Tables | |||
i want to transfer labels in word to an excel database | Microsoft Word Help | |||
Names and address list in Excel-mail merge to Word for labels | Mailmerge | |||
Labels with two names from EXCEL spreadsheet one name appears at t | Mailmerge | |||
How can I create labels from names and addresses in Excel? | Microsoft Word Help |