Angela wrote:
I have 10 pages of addresses. Each address is on one long line as
follows: "ANTIGUA AND BARBUDA Embassy of Antigua and Barbuda
Chancery: 3216 New Mexico Avenue, NW 20016 202-362-5211, (FAX
202-362-5225) "

I need to find a way to break this down into label format with having
to go through each one. Is there a way I can do that?

There's probably no way to avoid looking at and modifying each address,
unless they're absolutely uniformly formatted so that a macro could decide
where each piece starts and ends. Because addresses are typically not
uniform (different formats, apartment numbers, 5-digit vs. 9-digit postal
codes, etc.), that's unlikely.

In each address, place a marker (typically a tab character) between adjacent
parts of each address. If a part is missing, include its marker anyway.
There should be the same number of markers in each address. Using a vertical
bar to represent a tab here, the example might look like

ANTIGUA AND BARBUDA|Embassy of Antigua and Barbuda Chancery|3216 New Mexico
Avenue, NW|20016|202-362-5211|(FAX 202-362-5225)

When this work is complete, go to Table Convert Text To Table, choose
the marker as the separator symbol, verify that the conversion will create
the proper number of columns, and click OK. Insert one row at the top of the
table and insert names for the columns.

The resulting table can now be used as the source for a mail merge to
labels, as described in
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm. You may also find
useful information in
http://www.gmayor.com/convert_labels...mail_merge.htm, especially the
picture at the end that shows what the final table should look like.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.