Re: [libreoffice-users] Selecting record range in mail merge.

Hi,

I don't know if this might help anyone or not. I had an OpenOffice form 
problem using the table template with a standard 30 label sheet (3 x 
10). I have all of our Christmas card addresses in an OpenOffice 
database. I have the form setup, etc, to automatically pull the address 
information in when I click print and select the database, etc. It works 
great with one exception. Last year my wife said I missed having a few 
addresses included. I didn't think anything about it, and honestly, 
didn't think that was possible. This year before giving her the printed 
labels I thought I would check that everyone was there. I set the 
printing so it is sorting to print A_Z based on the last name. It takes 
three sheets. I have 78 names in the database, but only had 76 printed 
labels. What happened was when the printing went from the first sheet to 
the second sheet, it misses one record. The rest of the second page is 
fine. When I went from the second sheet to the third sheet, once again, 
it skipped the next label, then printed fine for the balance. When I say 
it skipped it, the missing record just disappears. It isn't that I end 
up with a blank label at the top of the sheet. The next one in line to 
be printed on the first label on Page 2 vanishes and the one that should 
be the second one on the second page becomes the first one on the second 
page. The same with the third page. A person would never pick this up 
unless checking the database against the printed labels.

The solution!!!!!!!! I had one full page of labels with the fields in. I 
read on-line that you need one complete page with fields in for each 
page of labels. So I added two more pages so I have a three page 
template. When I created Pages 2 and 3 and by pasting the complete page 
1, then scrolled up, I found there was a blank page between each label 
page. I deleted those pages, and I now have a perfectly working label 
template printing all of the address!!!!!!!!!

Don

On 08/22/2011 06:28 AM, Tom Davies wrote:
> Hi :)
> It's a fence-post error (i think).  "To" means "stop just short of", "up to&
> including" is what you want but i don't know of a better work-around than the
> one you are using.  If you were driving "into town" your first stop wouldn't be
> outside the far side of town.
>
> http://catb.org/jargon/html/F/fencepost-error.html
> http://www.dsm.fordham.edu/~moniot/Opinions/fencepost-error-history.shtml
> http://en.wikipedia.org/wiki/Off-by-one_error
>
> Regards from
> Tom :)
>
>
>
>
> ________________________________
> From: Steve Edmonds<steve.edmonds@ptglobal.com>
> To: users@global.libreoffice.org
> Sent: Mon, 22 August, 2011 3:48:28
> Subject: [libreoffice-users] Selecting record range in mail merge.
>
> Hi.
> When printing a mail merge/form letter you have the option to select a
> record range for the form data.
> If you select From 1 to 100 then records 1 to 99 inclusive are printed,
> record 100 is not.
> If you select record From 50 to 50 (so you can print just record 50)
> then a letter prints with no data from the data source (those fields
> left blank). To print record 50 you need to print From 50 to 51.
>
> I have LO 3.3.2 installed on SUSE which shows this bug and have filed
> bug 40278.
> https://bugs.freedesktop.org/show_bug.cgi?id=40278
> steve

--

***
*


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted