Re: [libreoffice-users] Labels

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