Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


I just completed a project where I produced the 422 labels needed for a mineral museum display which started with an Excel spreadsheet of the collection. I am using LibreOffice 3.4.3 on a Win7 64 bit system.

Here are the steps that I followed.

Creat a database (LibreBase) using the Excel spreadsheet as the source. Open a new database. On the opening "Welcome to the Database Wizard" screen select "Connect to an existing database" and select "Spreadsheet" from the drop down menu.

Then use the browse function to select the Excel spreadsheet file. The database will be created using the spreadsheet as data input. The column headings should become the database fields

Then click on the "Insert Labels" button on the top toolbar. This will bring up the Label Wizard which will run thru the steps to format the labels which are now in a new LO Writer file. The formating is done only in the first label. When you have it the way you want, click on the "Synchronize Labels" button which will then copy the formatting from the first label to all the others.

Once the labels are formatted, you use the Mail Merge Wizard which is in the Tools drop down menu in LO Writer.

For some reason, LO inserts a blank page between every label page when printing. [Does anyone know why?] They will show up in the Print Preview. These can be eliminated by going into the set up for LO (Menu>Tools>Options>LO Writer>Print then uncheck the box "Print Automatically Inserted Blank Pages"

Also when you print, (Use ctrl P) open the LO Writer tab and make sure that the same box is unchecked there too.

I may have forgotten some of the steps but this should help. If not let me know and will go back and run thru the steps again to see what I missed.

Hope this helps you.

Jerry



At 06:57 AM 12/3/2011, you wrote:
Hi
Using Windows 7
I have open office version 3.2 loaded
having converted all my previous word and excel programs
But I need to produce Christmas address labels from an original excel file
(converted to Calc)
I have followed the wizard but only produces a page for one address and none
of the others
Any help would be appreciated

Tks
Duncan
duncan@rowans.clara.co.uk


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.