More templates like this. Elegant labels (30 per page) Word Thousands of templates to jump start your project. Address books · Agendas · All Holidays. Amazon’s Choice for “avery ” .. I have used my own CD Label and Jacket templates (templates that I created myself) in CorelDraw and Adobe Illustrator. For easy identification of your CDs, create professional, eye-catching CD labels using the free templates and designs at Then print with a laser.
|Published (Last):||25 January 2008|
|PDF File Size:||2.32 Mb|
|ePub File Size:||16.24 Mb|
|Price:||Free* [*Free Regsitration Required]|
Hello, I am a new user to LibreOffice, and I’m finding my current quest to be a challenge. 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 avwry over records not the spinning kind that makes sound.
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 DVDand you would be surprised how often that is.
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 label 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.
With over records, that tends to get old real quick. It would appear that the software can not handle more than about records at a time 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 is not in the template list. Am I looking in the right area by coming to this forum? I could really ttemplate some pointers and direction on this one. I did find one template I think it was already made, but I could not for the life tempkate me figure out how to apply it to a database recordset.!
You say you are new to LO. Base is just a front end to a database. How familiar are you with databases?
Not very familiar with templates but looks square and for a case. Is this what you want? Your last sentence is where I face my problem I have no idea what template is I’m attempting to use the ones temppate I bought, Avery I am attempting to attach a link to a screenshot of my database. Maybe from there you can tell me if I have tdmplate wrong about it. You mentioned already in Base – is this embedded DB default?
How many labels are typically at one time? Never mentioned if experienced with DB’s. Already working on an answer for you but will take a bit of time. These answers will fill in some gaps. First let’s start with Base.
As briefly mentioned, Embedded is default but has its’ problems. It is in the. Therefore data should be kept separate from the. See this post on creation: Don’t be alarmed, it is really quite simple. You templat have two forms: This entries here will be used by the query to select records for printing from your master records. Finally, make sure the database is registered. This is necessary to use the data in avety modules such as Writer, Calc, etc.
To make this a bit easier, I have attached as a sample – CDLabels.
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. Since I have no knowledge in adding agery new label template to Avery list, I chose using the mail merge method here.
First I downloaded the template from the Avery site. Double clicking on that file opened it in Writer. Then did a Save as as a Template. Now we have the starting point.
Using the newly created template. Now this explanation averu already covered in the docs so I won’t go into detail here. See Chapter 11 – Using Mail Merge as a guide click here templtae docs. Here is a partial view I set up:. Again, the docs should help along the way.
Blank Label Printing Template – PDF & Doc Download
You will also need to add a field New Record between the two labels. Ratslinger Thank you for this information. Alas, however, it is the end of a very long work day for me, so I will need to look this over tomorrow when me brain isn’t quite as mushy or as they say in the south, “Your brain is FRIED like Aunt Bessie’s chicken after she’s nipped a few! One thing that I can already point out It’s only when I am creating ‘master’ labels for storage do I print several in a row. I’m sorry, but life has it’s ups and downs I’m still trying to get to performing the steps in your answer.
Please continue to bear with me. TXShooter It’s not a problem. Take care of what is necessary first.
I’m almost to a point of uninstalling LibreOffice. I can’t seem to import my spreadsheet data And while I was attempting to cancel an operation to Convert my Excel Spreadsheet, didn’t want to overwrite the existing fileI received an Access Denied to the. Your comment came out of nowhere. The topic has been about printing labels from a database and the next thing you mention is problems importing a spreadsheet.
Now I’ll be glad to try to help but I can’t see what you are doing. One step at a time. Sounds like you are trying to import data from an Excel Spreadsheet. What actual procedure are you following? What end result are you attempting to achieve?
The ultimate goal is to print labels, but I averyy need to update and keep the database of sermons, so why store and maintain it in a spreadsheet? I was attempting to follow these templaet Just did it again in about 30 seconds. Two things trouble me. First, are you going to use a split or embedded DB for Base. This was the first item I discussed in my answer concerning Base. Personally I would only consider split for the number of vaery you have.
Second, the instructions you pointed to say to copy data from CALC. You can open your Excel file in Calc and just save as Calc. As I indicated before about the “Convert my Excel Spreadsheet” into. I am attempting to utilize the split DB your instructions had me create. By re-saving, I mean to say that I had forgotten to update the file by Ctrl-S after I had added a few new entries.
How do I design a template for labels for CD/DVD that use a database? – Ask LibreOffice
I noticed these missed entries in Calc. And since I still had Templaate open with the new entries in it, I chose the path of saving that file, and attempted to re-convert it into an. The issue of getting that data into the DB is still not working as expected I don’t see any gap. You create the split DB. Have the Base file split DB open at at the Teplate section which is blank – no tables yet created.
The first row of the sheet should have column descriptions. These will be used for Field names. The rest of the rows are your data. Select ALL rows starting with the temppate. I think it is not just that this is so tough, but you should break your question into peaces.
MS Word 2010 and comparable Avery label Templates
To do that you probably have to educate yourself more, you cannot expect that other people do all the thinking for you. If I am allowed to do a little suggestion and please correct me if I am wrong: What kind of database should I create mysql or hsqldb or other?
How exactly do i create that DB and fill it? If you got all your data in that DB the last question would be how to print the labels from that DB? I see where I went wrong in my OP. I failed to mention that I have already imported into Base said database originally from Excel with fields and everything.