How Do I Convert Lables to spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PGCBOS01 - 08 Sep 2005 17:29 GMT

I received a file of labels in Word.

I want to reverse the process and convert the labels back into a usable mail
merge file. How do I do this?

Reply to this Message

Anne Troy - 08 Sep 2005 18:12 GMT

Try the lovely Graham's tip:
http://www.gmayor.com/convert_labels_into_mail_merge.htm
************
Anne Troy
www.OfficeArticles.com

>I received a file of labels in Word.
>
> I want to reverse the process and convert the labels back into a usable
> mail
> merge file. How do I do this?

Reply to this Message

PGCBOS01 - 08 Sep 2005 22:15 GMT

I tried the suggestion by Anne. The problem is that there is more than one
data field per line on the labels e.g., the last line of the labels is City,
State and Zip code - Pittsburg, PA 18018.

I am trying to divide the multiple data fields on each line into thier
respective colums

Please help.

> I received a file of labels in Word.
>
> I want to reverse the process and convert the labels back into a usable mail
> merge file. How do I do this?

Reply to this Message

Doug Robbins - 09 Sep 2005 05:34 GMT

Using a wildcard replace, you could insert carriage returns in place of the
comma and the space after the town and in place of the space between the
state and the zip.

See the article "Finding and replacing characters using wildcards"
http://www.word.mvps.org/FAQs/General/UsingWildcards.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I tried the suggestion by Anne. The problem is that there is more than one
> data field per line on the labels e.g., the last line of the labels is
[quoted text clipped - 11 lines]
>> mail
>> merge file. How do I do this?

Reply to this Message