Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Angela
 
Posts: n/a
Default One Long Line of Containing an Address

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?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman
 
Posts: n/a
Default One Long Line of Containing an Address

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.


  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Angela
 
Posts: n/a
Default One Long Line of Containing an Address

Thanks Jay! I was hoping to have to avoid that, but I guess I can't. I know
this will work fine.

"Jay Freedman" wrote:

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.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
double window envelope tpdebronsky Page Layout 5 May 18th 23 08:51 PM
Red dotted Line under address line how to get rid Dannie Microsoft Word Help 9 February 21st 06 07:30 PM
Mail Merge Address Block Missing Address 3 Joe Champagne Mailmerge 3 September 23rd 05 06:09 PM
Address Line Format for Mail Merge Misha Mailmerge 1 August 2nd 05 04:52 AM
extra long lines and word split at end of line without hyphenation RSA2004 Microsoft Word Help 1 January 28th 05 01:15 PM


All times are GMT +1. The time now is 10:54 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"