Printing Avery labels

[Razzman]

I have a project tracking database for recording leads and potential sales. I need to create file folders for each project to cache any paperwork. I may only create four or five folder labels at a time. It would be a natural to have a layout for printing these label from FMP but I don't want to waste an entire sheet of labels. Is there an answer that lest you print from a specified label position on a sheet of labels? I now have to export the data to DeskTopLabels Pro in order to accomplish this task. Thanks.

[LiveOak]

Several ways of doing this come to mind:

1) Use a conventional label layout with one label per record, pad the records to be printed with blank records, and sort to bring the blanks to the top (first labels). The number of blank records added would depend upon the label you wish to start on. It is often best to use a separate file for this purpose.

2) Use a single page form with one relationship for each label position. Code the records to be printed so that they appear where you want them to (the match the desired position relationship).

3) The best way might be to get a label printer. If you are using an ink jet printer, running label sheets through multiple times is OK. On a laser printer, it's not a good idea. The first label that wraps around the fuser roller will cost the same as a LOT of boxes of labels! I find that on the Mac side the Seiko's work much better than the CoStar's.

-bd

[Kurt Knippel]

quote:

---

Originally posted by LiveOak:

Several ways of doing this come to mind:

3) The best way might be to get a label printer. If you are using an ink jet printer, running label sheets through multiple times is OK. On a laser printer, it's not a good idea. The first label that wraps around the fuser roller will cost the same as a LOT of boxes of labels! I find that on the Mac side the Seiko's work much better than the CoStar's.

---

I gotta go with LiveOak's #3 on this one. Even if you are only printing the occassional odd label,and mostly full sheets, the effort to get this working is often more than the cost of a single label printer.

The small Seikos and such are great for the desktop as they are small and quite.

Correct me if I am wrong, but the only problem with them is that they are NOT networkable.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[Razzman]

These are all good ideas, but it brings up a few questions. 1) Are there 1/3 cut file folder lables available for the Seiko printer? 2) Can you print from FMP to one of these label appliances? 3) Not networkable, that doesn't seem to create a huge difficulty as long as they are USB capable, any knowledge on the interface? 4) I have been using TouchBasePro, Avery LabelPro and Desktop LabelPro for a million years. All allow for starting at any position on the sheet. I use ink jet and laser printes and have never encountered any problems. I recently had a new fuser installed in my LW8500 and it was over $500.00, not due to labels. I should probably heed your warnings though, because it would only take one label.

Thanks for the help!

quote:

---

Originally posted by captkurt:

I gotta go with LiveOak's #3 on this one. Even if you are only printing the occassional odd label,and mostly full sheets, the effort to get this working is often more than the cost of a single label printer.

The small Seikos and such are great for the desktop as they are small and quite.

Correct me if I am wrong, but the only problem with them is that they are NOT networkable.

---

[dryan]

You can use CoStar label printers on a network. I share one to an MS network and routinely print to it from FM5 on any workstation.

[danjacoby]

An addition to the original idea (i.e. blank records).

Create a number field, called "RecordNumber". Auto-enter zero. Then create the maximum number of "blank records" you'll ever need (one less than the total on a label sheet). Number each blank record (have one record equal 0.5, then sequence the rest from 1 to whatever it goes to).

Now create a global field that returns a number ("gRecordNumber").

When you're ready to print, do a find for all records with "RecordNumber" value less than the number of blank records you want, and sort by "RecordNumber".

And voila. You never need to create or delete these blank records again. A simple find/sort gets exactly what you want.

HTH,

Dan

[LiveOak]

CoStar printers may be fine on the PC side, but unless their drivers have gotten a LOT better, WYSIWYG is nonexistent on the Mac side. -bd

[SteveB]

quote:

---

Originally posted by brzasa:

I have a project tracking database for recording leads and potential sales. I need to create file folders for each project to cache any paperwork. I may only create four or five folder labels at a time. It would be a natural to have a layout for printing these label from FMP but I don't want to waste an entire sheet of labels. Is there an answer that lest you print from a specified label position on a sheet of labels? I now have to export the data to DeskTopLabels Pro in order to accomplish this task. Thanks.

---

For what its worth, I've run partial sheets thru an HP laserjet, but I wouldn't do it too often...I have had the sheet fuse to the toner cartridge. Once or twice more seems to work at least with the HP.

[leverenz]

I use Avery Mini-Sheets (#2180) 1/3 cut labels which have only 12 labels to a sheet. There's six on one side, flip it 180 and there's six on the other side. A simple label layout in FMP with one field "text" then create six records, View as List, line it up with your printer (I use a HP Deskjet 832C) by tweaking the layout until you get the desired results. If you have used up labels, just leave the records blank that line up with the labels used and you can make labels all day long. We use this daily in our contracting business and it works great!