OpenOffice.org Mailing Label Follies
charlescurley at charlescurley.com
Thu Apr 16 16:36:35 MDT 2009
On Thu, Apr 16, 2009 at 12:04:11PM -0600, Charles Curley wrote:
> I'm trying to generate mailing labels. I can create a template and a
> suitable database source. When I hit "print" I get the dialog, "Do you
> want to print a form letter?" So far so good. I generate a file so I
> can inspect the results before I print.
> The problem is, I have a page per addressee, and all of the labels on
> that page are duplicates. What I want is one label per addressee, so
> if I have N up labels, I'd have rows/N pages, not count(rows) pages.
> Any ideas?
You have to tell OOo to advance to the next record. Put the cursor
toward the end of the master label (upper left hand corner, the one
that gets replicated when you hit the "Synchronize Labels" button),
after the last field. Insert-> Fields-> Other-> Database. Select the
appropriate database and table. Then select "Next record", then
Charles Curley /"\ ASCII Ribbon Campaign
Looking for fine software \ / Respect for open standards
and/or writing? X No HTML/RTF in email
http://www.charlescurley.com / \ No M$ Word docs in email
Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: Digital signature
Url : http://plug.org/pipermail/plug/attachments/20090416/e5894e02/attachment.bin
More information about the PLUG