Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double window envelope | Page Layout | |||
Red dotted Line under address line how to get rid | Microsoft Word Help | |||
Mail Merge Address Block Missing Address 3 | Mailmerge | |||
Address Line Format for Mail Merge | Mailmerge | |||
extra long lines and word split at end of line without hyphenation | Microsoft Word Help |