[Doug Robbins - Word MVP]

Does the file containing the addresses have a line at the top that contains
the name of each field, each one separated by the semi-colon?

Regardless, you may find it easier to open the file and then select and copy
everything in it and paste it into a Word document (or just use FileOpen in
Word) and then in Word, select everything and use the Convert Text to Table
facility to convert it into a table. I did that with the two rows of data
from your post and after replacing the new line character at the end of the
first row with a carriage return (because of the way it is formatted in the
mail program), the Convert Text to Table facility automatically selected the
semi-colon as the character to use to separate the text.

If necessary, you can then insert a row at the top of the table into the
cells of which you type the field names to be used in the mail merge
process, such as

Name
Street
City
State

Zip

Also see the article €œMailmerge Labels with Word XP€� on fellow MVP Graham
Mayors website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

or €œMail Merge with Word 2007€� on fellow MVP Graham Mayors 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, originally posted via msnews.microsoft.com
"Clay Shannon" wrote in message
...
I am trying to populate Avery 5160 labels by using a file with contents
like
this (semicolon-delimited, one record per line):

Mr. Joe Brown; 123 Cypress Lane; Sausalito; CA; ;;; 54567
Mr. Merle Haggard; 456 Fiddlestix; Redding; CA; ;;; 55555

Does anybody have step-by-step instructions on how to accomplish this in
Word? I've tried everything I can get to and think of related to mail
merge
and creating labels in Word, and have had no success.