converting word list to excel data merge document
- From: SMPecorella@xxxxxxxxxxxxxxxx
- Date: Sun, 6 Apr 2008 18:22:51 -0800
Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I was recently sent a list of 250 names, addresses, etc., that I need to merge into form letters and labels. The info sent to me looks like this:
Ms. I Am In-Charge
In Charge, LLC
123 Main Street
Angel City, NY 22222
Phone: 212-333-3456
Fax: 212-333-3457
email: Iamincharge@xxxxxxxx
Mr. Leader Am I
Judge
Supreme Court of TX
456 Justice Ave.
Suite 200
Livin, TX 34567
Phone: ...
Fax...
email...
The entries range from at least six lines to no more than nine lines (some entries have PO Boxes and street addresses, or lines that would otherwise function as Address1 and Address2; other entries have the standard Address1, City, State, format.)
I have tried importing text data to excel --don't work. I've tried converting text to table in Word, but the columns and text aren't consistent and then I have to cut and paste to new rows. I've also tried copying text to excel work*** and converting text to table, but it will not expand to all of the necessary columns. Is there anyway to convert these 200-odd addresses to excel without re-typing everything manually?
.
- Follow-Ups:
- Re: converting word list to excel data merge document
- From: CyberTaz
- Re: converting word list to excel data merge document
- From: CyberTaz
- Re: converting word list to excel data merge document
- Prev by Date: Sorting/filtering 2 columns for data found in both columns.
- Next by Date: Re: autocomplete doesn't work
- Previous by thread: Sorting/filtering 2 columns for data found in both columns.
- Next by thread: Re: converting word list to excel data merge document
- Index(es):
Loading