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]