Creating address labels in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

greatmusic@comcast.net - 25 Jul 2007 20:06 GMT

I have a data base of names and addresses of businesses in Excel and I
would like to create a list of all of them with just their Names,
Addresses, City, State and Zip codes so I can print them out as labels
on standard sheets of labels from Office Depot.
Is this possible? It would save allot of time rather than writing
them out by hand.
Thanks for any help.

sus4

Reply to this Message

Bob Greenblatt - 25 Jul 2007 20:27 GMT

On 7/25/07 3:06 PM, in article
1185390385.680975.158160@w3g2000hsg.googlegroups.com,

> I have a data base of names and addresses of businesses in Excel and I
> would like to create a list of all of them with just their Names,
[quoted text clipped - 5 lines]
>
> sus4

Sure it's possible, but not terribly easy using just excel. Your best
approach is to use word and the mailing list manager. Use you Excel workbook
as a data source, and one of word's built in label templates. Check help in
WORD for examples. If you are still having trouble, post back here.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

JE McGimpsey - 25 Jul 2007 20:31 GMT

> I have a data base of names and addresses of businesses in Excel and I
> would like to create a list of all of them with just their Names,
> Addresses, City, State and Zip codes so I can print them out as labels
> on standard sheets of labels from Office Depot.
> Is this possible? It would save allot of time rather than writing
> them out by hand.

Your best bet is to use the XL workbook as the data source for a Word
data merge, using Word's Tools/Labels... wizard. There you can set your
label size exactly, and lay out your fields the way you want them.

See "Create labels by using the Data Merge Manager" in Word Help.

Reply to this Message

greatmusic@comcast.net - 25 Jul 2007 22:26 GMT

> In article <1185390385.680975.158...@w3g2000hsg.googlegroups.com>,
>
[quoted text clipped - 9 lines]
> data merge, using Word's Tools/Labels... wizard. There you can set your
> label size exactly, and lay out your fields the way you want them.

> See "Create labels by using the Data Merge Manager" in Word Help.

THANK YOU BOTH FOR YOUR QUICK REPLIES
I'LL LET YOU KNOW HOW I MAKE OUT.

Reply to this Message

greatmusic@comcast.net - 26 Jul 2007 23:05 GMT

On Jul 25, 5:26 pm, greatmu...@comcast.net wrote:

> > In article <1185390385.680975.158...@w3g2000hsg.googlegroups.com>,
>
[quoted text clipped - 14 lines]
> THANK YOU BOTH FOR YOUR QUICK REPLIES
> I'LL LET YOU KNOW HOW I MAKE OUT.

I GOT IT ......THANKS AGAIN FOR YOUR HELP.

Reply to this Message

Mac Forum / Applications / Excel / July 2007

Creating address labels in Excel