[mrfrenchy]

Hi, I have a word document with mailing labels. Is it possible to go
backwards and export this data into Excel? If so, details? Thanks a ton!

[macropod]

Hi mrfrenchy,

If your Word document was generated via a mailmerge, then the mailmerge data
source would probably be a better place to start exporting the data in a
format suitable for Excel.

If all you've got is a set of labels in Word, each formatted along the lines
of:
Title Init S_Nm
Company_Nm
Premises_Nm
Post_Addr
Locality State Zip
and/or:
Title G_Name S_Nm
Street_Addr
Locality State Zip
then you could easily enough turn these into sets of delimited fields like:
Title Init S_Nm, Company_Nm, Premises_Nm, Post_Addr, Locality State Zip
and:
Title G_Name S_Nm, Street_Addr, Locality State Zip

You can easily enough import these into Excel, but you'll have to deal with
labels that have fewer fields than others (eg no Company_Nm and/or
Premises_Nm) and you'll probably want to split the first and last lines of
the address blocks into their component parts also. Again, you'll have to
deal with missing data (eg no Init) and fields that might consist of more
than one word (eg S_Nm, Locality, State)

So, yes, you can do it, but you might have a lot of word to do to get it all
structured correctly if you start working from your Word document.

Cheers

--
macropod
[MVP - Microsoft Word]


"mrfrenchy" wrote in message
...
Hi, I have a word document with mailing labels. Is it possible to go
backwards and export this data into Excel? If so, details? Thanks a ton!

[Peter Jamieson]

Graham Mayor has some info. that may help at

http://www.gmayor.com/convert_labels...mail_merge.htm

Peter Jamieson

"mrfrenchy" wrote in message
...
Hi, I have a word document with mailing labels. Is it possible to go
backwards and export this data into Excel? If so, details? Thanks a ton!