Converting Labels to spreadsheet format

[John Earls]

I am trying to convert 10 individual MS Word 2002 files
(in a 2 column label format) sent to me.

Each mail list numbers over 250 printed pages x 30
records/page = 7500 names per list x 10 lists = 75,000
total records!

Too much to cut and past or re-key in.

These files are mail lists WITH THE FOLLOWING BASIC FORMAT

NAME, TITLE (IF AVAIL)
COMPANY NAME
ADDRESS 1
ADDRESS 2 (IF AVAIL)
CITY, STATE, POSTAL CODE

Depending on the information for each record, sometimes
below each record there is a space or two.

When I convert table [ table-convert-table to text ] to
text successfully, I get the list with varying numbers of
spaces in between each "record". The same is tru when I
save the file as a text only document.

Regardless, my end goal is to import all records into MS
Access or Excel to allow me to further query and sort in
unique ways.

Can anyone help me with specific instruction on this
conversion (to excel or Access)

 

[Jay Freedman]

Hi, John,

See Graham Mayor's article at
http://www.gmayor.dsl.pipex.com/convert_labels_into_mail_merge.htm.

Once you're done with his procedure, you'll have a nicely formatted Word
table. You can simply copy that to the clipboard and paste it into Excel.