Hello @TXShooter
Answers to my additional questions can be addressed when provided.
First let’s start with Base. With 3000+ records I would definitely recommend creating a split DB to contain the data. As briefly mentioned, Embedded is default but has its’ problems. It is in the .odb which can & has lost/damaged data. Therefore data should be kept separate from the .odb file. See this post on creation: click here. Don’t be alarmed, it is really quite simple.
Once you have an existing DB in place:
-
New table SELECTION
(for record selection) - two fields: ID (auto-increment); Selected Record (will use Record Number from your image). Example:
-
You will have two forms: one for regular entry maintenance; one for record selection of labels to be printed.
EDIT: For the two forms - Base the entry/maintenance form on your converted data table. Base the Selected record form on the newly created (and empty) SELECTION
table. This entries here will be used by the query to select records for printing from your master records.
-
You’ll also need a query for the actual selection.
-
Finally, make sure the database is registered. This is necessary to use the data in other modules such as Writer, Calc, etc.
To make this a bit easier, I have attached as a sample - CDLabels.odb
There are only two items in Master & only set up for selection for the query. With this setup you can print as many different labels as wanted in one process. But each time you use Selection, delete the old entries.
Now for Writer. Since I have no knowledge in adding a new label template to Avery list, I chose using the mail merge method here.
First I downloaded the #5697 template from the Avery site. Double clicking on that file opened it in Writer. Then did a Save as
as a Template (.ott file). Now we have the starting point.
Using the newly created template (.ott) and the query in Base, you can position fields for printing on the label. Make sure you place the same fields in both upper & lower labels so as to use both. Now this explanation is already covered in the docs so I won’t go into detail here. See Chapter 11 - Using Mail Merge as a guide (click here for docs). Here is a partial view I set up:
You can see a couple of fields I inserted & also some fixed text (“Copy” & “Media”).
Once all the necessary fields are applied (both upper & lower) and the query result records selected to be merged, from toolbar select Tools->Mail Merge Wizard
, you shoud have record(s) available to print or save. My sample result:
Again, the docs should help along the way. Important items are getting the DB query correct & the Writer template in the wanted format ( UPPER & LOWER - can’t stress enough).
EDIT: You will also need to add a field (New Record) between the two labels. Please excuse my slight knowledge in mail
merge/labels. DB’s more my forte.
Hope this points you in right direction.
EDIT 7/8/17:
Sample using Fontwork:
If this answers your question please click on the (upper left area of answer).