On 4/12/2006 11:16 AM, [EMAIL PROTECTED] wrote:
Bob: Very intriguing. It certainly sounds like you and I are doing the
exact same thing, but getting different results. I'm hoping that someone
will have some idea why. Ideas anyone?
Dick
PROBLEM SOLVED. Turns out the Calc spreadsheet had a single character
within the database structure at row 65535! I don't know how it got
there, but there it was. The data source assumed (correctly) that there
were 65535 rows/records of data, even though 99.99% were blank
rows/records.
-----Original Message-----
From: Bob <[EMAIL PROTECTED]>
To: [email protected]
Sent: Wed, 12 Apr 2006 10:20:31 -0400
Subject: [users] Re: Creating labels from database - more records than
fit a page
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
