#Avery 5697 how to#
#Avery 5697 pro#
#Avery 5697 software#
#Avery 5697 download#
#Avery 5697 free#

See Chapter 11 - Using Mail Merge as a guide ( click here for docs). Now this explanation is already covered in the docs so I won’t go into detail here.

Make sure you place the same fields in both upper & lower labels so as to use both. Using the newly created template (.ott) and the query in Base, you can position fields for printing on the label. Then did a Save as as a Template (.ott file). Double clicking on that file opened it in Writer. Since I have no knowledge in adding a new label template to Avery list, I chose using the mail merge method here.įirst I downloaded the #5697 template from the Avery site. But each time you use Selection, delete the old entries. With this setup you can print as many different labels as wanted in one process. There are only two items in Master & only set up for selection for the query. To make this a bit easier, I have attached as a sample - CDLabels.odb This is necessary to use the data in other modules such as Writer, Calc, etc. You’ll also need a query for the actual selection.įinally, make sure the database is registered. This entries here will be used by the query to select records for printing from your master records. Base the Selected record form on the newly created (and empty) SELECTION table. You will have two forms: one for regular entry maintenance one for record selection of labels to be printed.ĮDIT: For the two forms - Base the entry/maintenance form on your converted data table. New table SELECTION (for record selection) - two fields: ID (auto-increment) Selected Record (will use Record Number from your image). Don’t be alarmed, it is really quite simple. Therefore data should be kept separate from the. As briefly mentioned, Embedded is default but has its’ problems. With 3000+ records I would definitely recommend creating a split DB to contain the data. Hello to my additional questions can be addressed when provided.įirst let’s start with Base.

#Avery 5697 how to#

I did find one template (I think it was 5824) already made, but I could not for the life of me figure out how to apply it to a database recordset.! I did attempt to search this forum, but got frustrated that this specific question / feat / topic hasn’t been addressed yet (unless I missed it, for which I am truly sorry if that’s the case).Īm I looking in the right area by coming to this forum? I could really use some pointers and direction on this one. I was ecstatic to find out that LibreOffice supports many different labels, but I fell flat on my face when I realized that this specific label (5697) is not in the template list.

#Avery 5697 software#

It would appear that the software can not handle more than about 80-90 records at a time… it either crashes, or doesn’t process the records after some arbitrary point, and Avery’s online help is a step below dismal in this area. Avery 5697 2/3 x 1-3/4 Clear Easy Peel Laser Address Labels 34 min. With over 3000 records, that tends to get old real quick. I can not go to a specific record (I can go to the very first record, or the very last record, and then advance one by one up or down, but not to a specific record).

#Avery 5697 pro#

I have been trying to work around a couple of serious drawbacks to the Avery Designer Pro software that I would normally use on their 5697 label…

My database is about 15 years worth of sermons for my church, and it is used for when someone wants to get a copy of a sermon burned to a CD (or a copy of the video onto a DVD), and you would be surprised how often that is. I am needing to design a form in Base (or any combination of software within LO if that be the case) to display and print CD labels that use a database which contains over 3000 records (not the spinning kind that makes sound). Already have a completed design Upload Your Artwork.

#Avery 5697 free#

Choose a blank or pre-designed free template, then add text and images.

#Avery 5697 download#

Download template here Avery CD/DVD label template (MS Word document).I am a new user to LibreOffice, and I’m finding my current quest to be a challenge. Avery Template 5267 Design & Print Online. All sheets also contain 4 thin spine labels for the edge of standard CD Jewel Cases, for a total of 500 spine labels. Kit includes 125 sheets of genuine Avery CD/DVD white matte paper labels for all LASER printers, two (2) label per sheet. Subscribe to our weekly e-mail list to get savings news.ĮXTRA-LARGE 250- Pack: Avery #5697 Laser Print-to-the-Edge WHITE MATTE PAPER CD/DVD Labels - for Laser Printers, Print-to-the-Edge, Labels Included: Permanent-Adhesive, (a) CD Labels, White Matte Paper, 125 Sheets, 2 Labels per Sheet, for 250 Total CD Labels. Sales Hotline: 80 Monday-Friday 8am-5pm PT Cart & Checkout | Questions? | Front Page | Order Tracking