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]

Reply via email to