(Apologies for the top posting, the system I'm on at the moment doesn't
neatly do bottom posts.)
Bob: Thanks for following the process in the Mail Merge guide, and for
providing feedback on the outcome.
I'm puzzled as to why you are seeing all of the blank rows (out to
65,535 presumably). I replicated what you were doing, as well as I
could:
- I created a new spreadsheet with 34 records.
- I went through the process of creating labels, as described in the
Mail Merge chapter.
- I clicked New Document.
- I selected File > Print, and said Yes to the dialog asking if I
wanted to print a form letter.
- At the next step, when you can select all records or certain records,
I scrolled down to the 34th record in the database, and there were no
blank lines beyond that record. This is different than what you
observed.
- I accepted the default selection to print All records, sent it to the
printer, and got two sheets of labels, the first sheet with 30 labels
(3 columns times 10 rows), and the next sheet with the remaining 4
labels. There was no indication that "label x of 65,535" was being
created, which occurred when you tried it.
Maybe someone with more knowledge about databases than I have can
determine what could be going on. It almost seems like your database
thinks it has 65,535 records, with all records after the 34th record
having no visible content, but still being recognized as records.
I'm using OOo 2.0.3 with Windows XP, by the way.
What is your database source? (Calc spreadsheet, Excel spreadsheet,
other type of file?) If it's something other than a Calc spreadsheet,
maybe there is a clue there somewhere.
Dick Detwiler
-----Original Message-----
From: Bob <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wed, 12 Apr 2006 07:59:09 -0400
Subject: [users] Re: Creating labels from database - more records than
fit a page
On 4/12/2006 2:52 AM, Cor Nouws wrote:
> Hi Bob,
> > Bob wrote:
> >> On 4/9/2006 4:36 PM, Cor Nouws wrote:
> > >>>
>> This is really frustrating. > > [...]
> >>
>> All I want OOo to do is create/print 34 labels.
>>
>> I can't explain why the Mail Merge (with labels) wants to create
65535 >> labels!
>>
> > No idea.
> There is a realy good step by step guide:
>
http://oooauthors.org/en/authors/userguide2/writer/published_final/0211WG
-UsingMailMerge.pdf
I think I've found the problem and a work-around solution.
I followed the Mail Merge guide to register (reregister, actually) the
database source, and then proceeded to Printing Mailing Labels (page 8
of the guide; page 12 of 35 of the PDF file). Everything went smoothly
until page 10 & 11 of the guide, at step 8. I originally clicked on
Records/All, then OK (step 9). I did not select any records. At that
point the Mail Merge box showed that it was creating page letter x of
65535 and I stopped the process.
The next time I clicked on Records/Selected Records, and highlighted
all of the records (not any of the empty rows which followed the actual
records). It created only the selected 34 records and printed them
directly to the printer.
I now realize the problem is that when the mail merge dialogue
appears, it is "looking" at all of the rows in the OOo Calc spreadsheet
(which is the database) - all 65535 of them! In the dialogue, I can
scroll down through the empty rows; although I didn't go to the bottom,
I suppose the number would have been 65535!
I don't know if this is a bug in the 2.0.x (newest) version or if it's
an anomoly with my system for whatever reason. Either way, I must
select specific records, even if it is all of the records, in order to
avoid creating 65535 labels (and I presume any other mail merge
document) even when following the instructions in the Using Mail Merge
guide. The guide itself implies in the Printing Mailing Labels section
page 8 that if you want to print all of the records, you do not need to
select any records.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
