printing single or sheet labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a retired educator and I am establishing an online business for my daughter (selling papyrus). Could someone inform me where to post the following (despite frequent searches I am going around in circles at present and I would like to enjoy some part of my retirement in the not too distant future!). I would like to set up an automatic labeler, information hopefully automatically obtained from an Access database (Learning Access which is another story). Any advice whether I should print a sheet of labels (probably 30 per sheet) or is there a way to print out single labels (I'm assuming in both cases the label would e automatically filled in). Are these types of questions on any list, in particular, Is there a specific type of label maker (or labels that will be manually pasted on 10"x13" envelopes) that I should consider purchasing namely that is recommended to work with Access and is there any place where these matters are discussed - thanks.
 
Microsoft Word is great for printing labels. The mail merge feature
works great as well. Avery used to offer a free add-in that could
be downloaded from Microsoft to print on their labels.

Basically the way it would work, is you would either have a
single label that would be printed out on a whole sheet or you'd
see the whole page of labels and enter the necessary data for
each label. It's been about 4 years since I've used it but it was
great in 2000.

Maybe someone else might have used it a little more recently and
could throw a line in.

http://www.avery.com/us/Main?action=software.AverySoftwareDetail&catalogcode=WEB01&softwarecode=3201

Watch the word wrap on the link above.

There's a link at Microsoft that explains the mail merge features
of Word:

http://support.microsoft.com/?kbid=294684

Hope that helps.
 
Jim is correct, Word will do this quite well and is capable of using and
Access file as its data source. You can also do this in Access by creating a
report. There is a label wizard option when you create a new report that may
help you. What type of label you print on and how many per sheet will be
dependent on your printer and the size of label you want. Also, to get
Access to start at a certain label when you have a partially used sheet
requires some VB coding in the report. Of course, this wouldn't be a problem
for a label printer that uses a roll of labels one at a time; however, the
selection of label stock may be more limited, but I don't know that for
sure.
 
Thank you for all the info and pointing me in the right direction. I'll follow through and come back if I need to - thanks.
 
Back
Top