On 4/12/2006 9:56 AM, [EMAIL PROTECTED] wrote:
(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.
A OOo Calc spreadsheet with 34 rows of data. I followed the directions
in the Mail Merge Guide for linking to a database.
I just now, as a test, created a new Calc spreadsheet by copying only
the data from the original spreadsheet to a new one, then registering
the new spreadhsheeet as the data source, creating new labels based on
that spreadsheet. When I followed the Mail Merge guide, I got the same
results - it wanted to create 65535 labels.
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]
