Creating Mailing Labels

February 23, 2009 at 10:01:33
Specs: Windows XP, N/A
I have a list of addresses that I need to print mailing labels for on Avery 5660 label sheets. The program (Ticketmaster) I am using gives the names and addresses in one column in MS Word. Is there anyway I can format this into a label template without copying and pasting them all? Thanks!!

Ex:
HASSAN ABDUL-SHARIF
145-30 224TH STREET
SPRINGFIELD GARDENS, NY 11413

CAROL JEAN ADAMS
21 Q JANE LACEY DR
ENDICOTT, NY 13760-3729

PETER G AHERN
3092 S. COOK STREET
DENVER, CO 80210


See More: Creating Mailing Labels

Report •


#1
February 23, 2009 at 10:18:42
It's possible, but why in the world would you post legitimate names and associated addresses on a Public Forum?

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

#2
February 23, 2009 at 10:20:28
One suggestion:

Open the Excel Help files and search on "labels".

The second entry in my list was:

Print labels by using Excel data in a Word mail merge

Maybe you could copy your list from Word to Excel and then use Word's Mail Merge feature to print your labels.


Report •

#3
February 23, 2009 at 10:21:15
The names and addresses do not match. It was an EXAMPLE.

Status: UNRESOLVED


Report •

Related Solutions

#4
February 23, 2009 at 11:41:12
Not according to switchboard.com. Those are valid names and associated addresses in the second and third entries.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

#5
February 23, 2009 at 22:12:24
I don't care. This is a computer forum not the Internet police. Maybe you should take it up with "switchboard.com" then if they have it online. Addresses are public domain and are available in any phone book. There's no need to flood these message boards with your nonsense.

I have still been unable to resolve this issue. I cannot use mail merge because the data is not in separate columns.


Report •

#6
February 24, 2009 at 16:29:27
If you're too stupid to follow common sense in regards to other people's information, you're too stupid to understand a reasonable answer even if it is given to you.

Who in their right mind would ever need more than 640K of RAM!?
Bill Gates, 1981


Report •


Ask Question