Mailing label changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sacramento CA - 17 Jan 2008 20:45 GMT

I was given a file of mailing labels in Avery 5160 format. How do I change
them to Avery 5164? I do not want to retype them because there are over 100
names.
I am using Word 2003.

Reply to this Message

Doug Robbins - Word MVP - 17 Jan 2008 21:34 GMT

See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
website at:

http://www.gmayor.com/convert_labels_into_mail_merge.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 was given a file of mailing labels in Avery 5160 format. How do I change
> them to Avery 5164? I do not want to retype them because there are over
> 100
> names.
> I am using Word 2003.

Reply to this Message

Sacramento CA - 17 Jan 2008 23:12 GMT

I used the link. Thank you. It looks very complicated, but I'll try it.

> See "Convert Labels into Mail Merge Data File" on fellow MVP Graham Mayor's
> website at:
[quoted text clipped - 6 lines]
> > names.
> > I am using Word 2003.

Reply to this Message

Graham Mayor - 18 Jan 2008 07:21 GMT

Not so much comllicated as comprehensively illustrated ;)

Signature

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

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

> I used the link. Thank you. It looks very complicated, but I'll try
> it.
[quoted text clipped - 17 lines]
>>> names.
>>> I am using Word 2003.

Reply to this Message

Graham Mayor - 18 Jan 2008 09:01 GMT

Or even 'complicated' ;)

> Not so much comllicated as comprehensively illustrated ;)
>
[quoted text clipped - 22 lines]
>>>> names.
>>>> I am using Word 2003.

Reply to this Message

Sacramento CA - 18 Jan 2008 19:26 GMT

I followed the instructions, and it worked... sort of. I found out why...
the file they sent me was a partial mail merge file, meaning some addresses
(highlighted gray) are in mail merge address format and some addresses are
just typed in. SO, the addresses that are just typed in converted, but the
mail merge field-style addresses did not convert. I asked for the database
the addresses came from, but that database no longer exists. I will have to
do some cut and paste, but will figure it out. Thank you.

> Or even 'complicated' ;)
>
[quoted text clipped - 24 lines]
> >>>> names.
> >>>> I am using Word 2003.

Reply to this Message