easy mailing labels ? - WarmGlass.com

easy mailing labels ?

The forum for discussion on business aspects of working with glass.

Moderator: Brad Walker

Post Reply
Monica
Posts: 17
Joined: Thu Mar 13, 2003 3:37 pm

easy mailing labels ?

Postby Monica » Sun May 04, 2003 11:39 pm

My mailing list is not large enough to make it worthwhile to use a mail house, so I'm still sending from home. However, the mailing list is large enough that I don't want to handwrite all the addresses. SO...What is an easy way to use an excel spreadsheet (or similar) to print labels and what label product works well (doesn't smear or jam a laser or ink jet printer). I'm sure there are loads of label products available at the local office supply place, but I'd like to know which products people like best.

watershed
Posts: 166
Joined: Wed Mar 12, 2003 1:44 am

Postby watershed » Sun May 04, 2003 11:54 pm

Do you use an accounting software (quickbooks etc)? Sometimes the upgraded version will have that feature.

Greg

Brad Walker
Site Admin
Posts: 1345
Joined: Fri Mar 07, 2003 9:33 pm
Location: North Carolina, USA
Contact:

Postby Brad Walker » Mon May 05, 2003 12:24 am

Use the Mail Merge Wizard that's part of Microsoft Word. It allows you to put address information in an Excel spreadsheet and then print them out from Word on regular labels that any office supply store will have (Avery is the major brand available).

You can find the Mail Merge Wizard under the Tools option in Word.

Carol
Posts: 112
Joined: Sun Mar 09, 2003 5:48 pm
Location: Thetis Island, BC, Canada
Contact:

Postby Carol » Mon May 05, 2003 10:57 am

Avery labels work well. They also have a downloadable Avery Wizard that can be downloaded that will set up your addresses for any size and type of label they make.

Monica
Posts: 17
Joined: Thu Mar 13, 2003 3:37 pm

thanks all

Postby Monica » Mon May 05, 2003 8:30 pm

I finally came to the same conclusion...MS Word mail merge, though it took me several attempts to figure out how to get mail merge loaded on to the pull down menu. [which is where I was stuck before...thinking that I didn't even have that option on my software version]. Bought some Avery labels today, and I'm on my way.

Barbara Cashman
Posts: 151
Joined: Sun Mar 09, 2003 5:42 pm
Location: Greensboro NC
Contact:

Postby Barbara Cashman » Fri May 09, 2003 5:58 pm

Another option, since I think you have MS Office, then you also have Access. Access is a "list type" program. I don't use it, but the few times I got into it, it has some interesting features for organizing a mailing list. - Barbara

Tony Smith
Posts: 1037
Joined: Sun Mar 09, 2003 5:59 pm
Location: Massachusetts, USA
Contact:

Postby Tony Smith » Fri May 09, 2003 7:28 pm

Access can certainly handle mailing lists, but it is so much more than that. But it only comes with the higher end MS Office: Office Professional.

Tony
The tightrope between being strange and being creative is too narrow to walk without occasionally landing on both sides..." Scott Berkun

Bert Weiss
Posts: 2337
Joined: Tue Mar 11, 2003 12:06 am
Location: Chatham NH
Contact:

Re: easy mailing labels ?

Postby Bert Weiss » Fri May 09, 2003 8:20 pm

Monica wrote:My mailing list is not large enough to make it worthwhile to use a mail house, so I'm still sending from home. However, the mailing list is large enough that I don't want to handwrite all the addresses. SO...What is an easy way to use an excel spreadsheet (or similar) to print labels and what label product works well (doesn't smear or jam a laser or ink jet printer). I'm sure there are loads of label products available at the local office supply place, but I'd like to know which products people like best.


If you happen to have a Macintosh using system 9 or earlier, Email me and I'll send you an easy program to use.
Bert

Bert Weiss Art Glass*
http://www.customartglass.com
Furniture Lighting Sculpture Tableware
Architectural Commissions

dee
Posts: 302
Joined: Tue Mar 11, 2003 5:20 pm
Location: Atlanta GA
Contact:

Re: easy mailing labels ?

Postby dee » Fri May 09, 2003 8:48 pm

Monica wrote:My mailing list is not large enough to make it worthwhile to use a mail house, so I'm still sending from home. However, the mailing list is large enough that I don't want to handwrite all the addresses. SO...What is an easy way to use an excel spreadsheet (or similar) to print labels and what label product works well (doesn't smear or jam a laser or ink jet printer). I'm sure there are loads of label products available at the local office supply place, but I'd like to know which products people like best.


hi monica - use labels that can be run thru your printer - offce depot and staples have store brands that work well and are equivalent to the avery flavors while much cheaper. download the avery wizard sw from the avery site and install it, use that with an excel spreadsheet to create mailing labels or postcards with the address and barcode printed right on it - i have a web client whose mailing lists i'm managing and i use word to create the front side of the cards with pics/website addy, then with an excel file full of addresses, i use the avery wizard within word to do all the text on the back with return addy, shows dates/locations and the addresses with barcode - works pretty well .....

D
Dee Janssen
Unicorn's Creations Studio
http://ucjewelry.com
dee@ucjewelry.com

Carol
Posts: 112
Joined: Sun Mar 09, 2003 5:48 pm
Location: Thetis Island, BC, Canada
Contact:

Re: easy mailing labels ?

Postby Carol » Sat May 10, 2003 11:04 am

dee wrote:
Monica wrote:i have a web client whose mailing lists i'm managing and i use word to create the front side of the cards with pics/website addy, then with an excel file full of addresses, i use the avery wizard within word to do all the text on the back with return addy, shows dates/locations and the addresses with barcode - works pretty well .....

D


Dee...what kind of printer are you using? I've been unable to get colour prints out of my printer that I'm happy using as promo material.

Carol

Bert Weiss
Posts: 2337
Joined: Tue Mar 11, 2003 12:06 am
Location: Chatham NH
Contact:

Re: easy mailing labels ?

Postby Bert Weiss » Sat May 10, 2003 1:49 pm

Carol wrote:
dee wrote:
Monica wrote:i have a web client whose mailing lists i'm managing and i use word to create the front side of the cards with pics/website addy, then with an excel file full of addresses, i use the avery wizard within word to do all the text on the back with return addy, shows dates/locations and the addresses with barcode - works pretty well .....

D


Dee...what kind of printer are you using? I've been unable to get colour prints out of my printer that I'm happy using as promo material.

Carol


Carol

Get a new printer. Every year they get better and better color prints.
Bert



Bert Weiss Art Glass*

http://www.customartglass.com

Furniture Lighting Sculpture Tableware

Architectural Commissions

dee
Posts: 302
Joined: Tue Mar 11, 2003 5:20 pm
Location: Atlanta GA
Contact:

Re: easy mailing labels ?

Postby dee » Sat May 10, 2003 1:59 pm

Dee...what kind of printer are you using? I've been unable to get colour prints out of my printer that I'm happy using as promo material.

Carol[/quote]

carol, i have a canon 8200 photo printer - just looked at canon printers for one of my web clients about a month ago, thre's a new one that is comparable to what i have - bought mine a few years back specifically for catalogs, brochures, postcards - canon i950 - i love my individual ink tanks..... prints great - i use the avery matte postcards

D
Dee Janssen
Unicorn's Creations Studio
http://ucjewelry.com
dee@ucjewelry.com

Ron Bell
Posts: 45
Joined: Wed Mar 12, 2003 12:31 am
Location: Middleburg, Florida

Postby Ron Bell » Wed Jun 04, 2003 4:50 pm

Carol, the Epson 825 produces truly photo-quality prints. You can find them on ebay from time to time for around $100. I use this printer for jury photos from a 3.2 megapixel camera and they are Greaaat!
Ron Bell
Black Creek Glass


Post Reply

Return to “Business Topics”

Who is online

Users browsing this forum: No registered users and 7 guests

Warm Glass

2575 Old Glory Road, Suite 700
Suite 700
Clemmons, NC 27012
Phone: (336) 712 8003
Email: wg@warmglass.com