Printing Address Labels

rickapple · May 13th, 2002, 01:10 PM

I got elected "News Letter Editor" for the Ski Club and I have a spread sheet with the following columns:

First name, Last name, Address, City, State, Zip code

I want to print this inforamtion to a 3-1/2" wide by 1" high label and cannot figure how to do such (thus crating an address label).

Please help....elected...haaa.....

Nimrod · May 13th, 2002, 01:16 PM

Word has a function exactly for this purpose called Mail Merge, that will allow you to create a label ( it will even ask what type of labels your using) and let you point to excel as your database.
Goto word and look up help on mail merge.

Tool bar path
-Word
--Tools
---Mail Merge
----Create
-----Mailing Labels

_________________
NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions.

[ This Message was edited by: Nimrod on 2002-05-13 12:19 ]

[ This Message was edited by: Nimrod on 2002-05-13 12:20 ]

klb · May 13th, 2002, 01:36 PM

The Report: Label Wizard in Access can do this for you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 01:10 PM	#1
rickapple New Member Join Date: May 2002 Location: Rick Posts: 1	I got elected "News Letter Editor" for the Ski Club and I have a spread sheet with the following columns: First name, Last name, Address, City, State, Zip code I want to print this inforamtion to a 3-1/2" wide by 1" high label and cannot figure how to do such (thus crating an address label). Please help....elected...haaa.....

May 13th, 2002, 01:16 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Word has a function exactly for this purpose called Mail Merge, that will allow you to create a label ( it will even ask what type of labels your using) and let you point to excel as your database. Goto word and look up help on mail merge. Tool bar path -Word --Tools ---Mail Merge ----Create -----Mailing Labels _________________ NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may need tweaking for other versions. [ This Message was edited by: Nimrod on 2002-05-13 12:19 ] [ This Message was edited by: Nimrod on 2002-05-13 12:20 ]

May 13th, 2002, 01:36 PM	#3
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	The Report: Label Wizard in Access can do this for you.