Hi Duncan,
It sounds like you have setup your fields properly in Excel, and now
calc. I personally use base, but it doesn't matter. I use the table
style templates available from the worldlabel.com site for
OpenOffice/LibreOffice. If you are using those, do not use the label
wizard, but go to insert/fields/other. In that window choose the
Database Tab, then select mail merge, and drag the fields you want to
your label form. Once you are done with that, in the same column as the
mail merge selection choose next record and click insert. Once you have
one label done, then simply copy the information from the first cell to
the other cells. When you print each label should have the correct
information from your source database.
You will have two other issues if printing more than one page. First, a
blank page will show up between each printer page. Second, one label
between each sheet will disappear. Here is how to fix those issues:
Hi,
I don't know if this might help anyone or not. I had an OpenOffice
form problem using the table template with a standard 30 label sheet
(3 x 10). I have all of our Christmas card addresses in an OpenOffice
database. I have the form setup, etc, to automatically pull the
address information in when I click print and select the database,
etc. It works great with one exception. Last year my wife said I
missed having a few addresses included. I didn't think anything about
it, and honestly, didn't think that was possible. This year before
giving her the printed labels I thought I would check that everyone
was there. I set the printing so it is sorting to print A_Z based on
the last name. It takes three sheets. I have 78 names in the database,
but only had 76 printed labels. What happened was when the printing
went from the first sheet to the second sheet, it misses one record.
The rest of the second page is fine. When I went from the second sheet
to the third sheet, once again, it skipped the next label, then
printed fine for the balance. When I say it skipped it, the missing
record just disappears. It isn't that I end up with a blank label at
the top of the sheet. The next one in line to be printed on the first
label on Page 2 vanishes and the one that should be the second one on
the second page becomes the first one on the second page. The same
with the third page. A person would never pick this up unless checking
the database against the printed labels.
The solution!!!!!!!! I had one full page of labels with the fields in.
I read on-line that you need one complete page with fields in for each
page of labels. So I added two more pages so I have a three page
template. When I created Pages 2 and 3 and by pasting the complete
page 1, then scrolled up, I found there was a blank page between each
label page. I deleted those pages, and I now have a perfectly working
label template printing all of the address!!!!!!!!!
Hopefully this will help you!!!!!!
Don
On 12/03/2011 08:57 AM, Duncan Sanders 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
dun...@rowans.clara.co.uk
--
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at
_www.cbur-ruralproperty.com <http://www.cbur-ruralproperty.com/>
_View Don's Farm Web Site at www.myersfarm.com <http://www.myersfarm.com/>
*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
--
For unsubscribe instructions e-mail to: users+h...@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