Transfer Names from Excel to labels in Words

[MH]

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

[Doug Robbins - Word MVP]

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 Copy>Paste Special>Transpose 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_labels_with_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