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.