Issue 8082 - Cannot create mailing labels for all records in a database at one time
Summary: Cannot create mailing labels for all records in a database at one time
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: h.ilter
QA Contact: issues@sw
Keywords: oooqa
: 11803 13326 15565 15634 15650 (view as issue list)
Depends on:
Reported: 2002-10-06 06:14 UTC by vreid47362
Modified: 2003-09-08 16:56 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description vreid47362 2002-10-06 06:14:59 UTC
I cannot select all of the records in a database table and print them as 
labels.  Open Office only wants to print one page of labels.  Is this an 
error?  Am I doing something wrong?  If it is an error, is there a patch?

Thanks for your help.

Vaughn Reid
Comment 1 Frank Schönheit 2002-10-07 08:26:07 UTC

please what exactly are you doing? Your description is somewhat ...
sparse. Can you please describe in more detail what the problem is?


PS: re-assigning this to the QA team lead - this is most probably a
Writer issue (if any), because label generation is done in the Writer
(if I am correct), it only _uses_ the data access component.
Comment 2 Frank Schönheit 2002-10-07 08:30:58 UTC
s/QA team lead/Writer QA team lead/
Comment 3 vreid47362 2002-10-07 14:51:12 UTC
I have a database of information about my volunteers that I use.  The
>database is a MySQL database (although, I tried the same thing with 
>Access database with the same results).  I need to be able to create 
a set
>of mailing labels for each volunteer in the database.  I need 1 
label per
>volunteer.  When I click on the New, Labels feature in Open Office 
>following events occur.
>1.    It creates a template with the proper fields included.
>2.    I add the next record command to the list of fields.
>3.    I go to the database connection for the volunteer database and 
>all the items in the appropriate table
>4.    When I click the Data to Fields button, however, it only 
creates one
>page of labels.
>In order to print all of the volunteers out, though, it should print 
>10 pages of labels.
>In addition to this approach, I also tried doing the labels as a form
>letter.  I tried saving it to file and the computer wanted to print
>approximately 2500 pages.  I also saved it to file and stopped the 
>when there were 1300 new files on my computer!
>Now, I can create a template for mailing labels and make it several 
>long and all of the volunteers will merge properly.  But this is 
sort of a
>pain bacause I have to adjust the size of the table each time to 
print all
>the labels without over printing or under printing (our number of 
>volunteers changes from month to month).
>I hope this contains enough information for you to help me.  If it 
>email me again and I'll try to supply any more details that I can 
think of.
Comment 4 rogerathome 2003-04-26 11:12:00 UTC
I can reproduce this. When I have 100 labels or so I cant generate
more than one page at a time.
Comment 5 prgmgr 2003-06-20 19:51:04 UTC
*** Issue 11803 has been marked as a duplicate of this issue. ***
Comment 6 prgmgr 2003-06-20 19:58:16 UTC
*** Issue 13326 has been marked as a duplicate of this issue. ***
Comment 7 prgmgr 2003-06-20 19:59:00 UTC
*** Issue 15634 has been marked as a duplicate of this issue. ***
Comment 8 prgmgr 2003-06-20 19:59:54 UTC
*** Issue 15650 has been marked as a duplicate of this issue. ***
Comment 9 prgmgr 2003-06-20 20:06:55 UTC
Back to the Writer team.
Comment 10 prgmgr 2003-06-20 20:32:36 UTC
Hello all.


Use the mail merge feature to create a print job or files that have
all the database/data source information populated into the label
document.  As far as I know, OOo does not support the creation of a
single document with all the labels filled in with the data source
data, especially when using the "Data to Fields" command.


OOo does not work like MS Word where the creation of labels will
generate in the original document multiple pages of populated labels.

Users must use the mail merge feature to create labels for all the
records in the data source.


You could try printing to a file, or use the save to file feature in
the mail merge options.


I'm closing this case, but I would encourage the users to create a new
feature request, detailing how label generation is intuitive for them.
Comment 11 prgmgr 2003-06-20 20:32:47 UTC
Comment 12 rogerathome 2003-06-20 21:32:58 UTC
Hi all. I reopened this issue with number 15878. Please vote for it!!
Comment 13 jensja 2003-07-27 18:55:33 UTC
*** Issue 15565 has been marked as a duplicate of this issue. ***