Envleopes to labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mel - 23 Aug 2004 16:28 GMT

I have a file of 120 envelopes (not my idea!) and I would
like to convert them to labels for a large mailing. I
cannot find any information on a way to either export
them to Excel or convert the envelopes into labels.
Every time I go into the mail merge wizard it tells me
that it will have to delete all of the contents to change
the size. Any suggestions? (I'm not sure where this
should go so I'm posting it in a couple of different
groups.)

Reply to this Message

Graham Mayor - 23 Aug 2004 17:58 GMT

Define 'file' in this context. Is this a single document, or a lot of
individual documents?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a file of 120 envelopes (not my idea!) and I would
> like to convert them to labels for a large mailing. I
[quoted text clipped - 5 lines]
> should go so I'm posting it in a couple of different
> groups.)

Reply to this Message

Mel - 23 Aug 2004 18:19 GMT

It's a single document consisting of envelopes with the
mailing address only (no return address).

>-----Original Message-----
>Define 'file' in this context. Is this a single document, or a lot of
[quoted text clipped - 11 lines]
>
>.

Reply to this Message

Doug Robbins - 24 Aug 2004 00:50 GMT

Save the document as a .txt file and that will strip out all of the envelope
formatting and (after you close and then reopen it) leave you with a file
containing just the address details. Then use the information on fellow MVP
Graham Mayor's website at
http://www.gmayor.com/convert_labels_into_mail_merge.htm to convert the
information into a form that can be used as a datasource for producing
labels.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> It's a single document consisting of envelopes with the
> mailing address only (no return address).
[quoted text clipped - 17 lines]
>>
>>.

Reply to this Message

Mel - 24 Aug 2004 16:20 GMT

Thank you very VERY much! I never would have figured
that out on my own. It worked like a charms, though.

>-----Original Message-----
>Save the document as a .txt file and that will strip out all of the envelope
[quoted text clipped - 28 lines]
>
>.

Reply to this Message

Rate this thread: