I wish mail merge and form letter would be distinguished. Are you
merging to mail or a printed form (that may be a letter).
I regularly mail merge (though it is a form merge and not to any mail
application) from an ods sheet, can you dump the mysql data to merge to
a sheet and then do your merge.
On 2012-10-17 09:59, Tom Davies wrote:
That does sound rather painful! Even given Base's current almost complete lack of support in LO it
must surely be possible to do a proper mail-merge! I thought this had been fixed ages ago.
To quote Andreas "Most of the Base community resides on
http://user.services.openoffice.org/en/forum/ which is also reachable
under the forum.openoffice.org domain.
There you find a search utility, tutorials, screenshots, example
documents and macros. On that forum you find two or three Base experts
at any time."
If you haven't already been told about that forum then i can only apologise!
Apols and regards from
From: Heinrich Stoellinger <firstname.lastname@example.org>
To: "email@example.com" <firstname.lastname@example.org>
Sent: Tuesday, 16 October 2012, 8:31
Subject: [libreoffice-users] Serial Letters
A couple of versions ago of LO I mentioned that I have a problem
with serial letters using Writer and MySQL-Views through Base.
When printing a letter "populated" with database-view variables
>from just ONE tuple (=record) everything is fine. Unfortunately,
when selecting MORE than one tuple for printing, various different
content of the letter gets left out in all letters following the
This might be "fixed" text (i.e. NOT from the db), graphics, but also
variables that should be included from the database.
Has anybody had the same experience?
I am now at LO 3.6.3-rc1 under Linux-Mint-Maya and use the native
MySQL-connector, but the same problem was present in earlier, stable
releases of both LO and MySQL (using a JDBC or ODBC connection).
When having to print - say - 150 letters, the fact that at present
I would have to print EVERY letter individually is unacceptable.
It certainly would prevent using LO in a business context!
I wonder whether anybody else has had the same experience.
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy