History: Mail Merge

Some use cases

!!# Simple: Customized messages from Newsletters
Tiki newsletter allows composing the message to recipients taken from the emails shown from a smarty template which is fed from a tracker. The idea is to extend the system to allow the newsletter body to be composed based on the smarty template itself, allowing to add values from fields in spefici parts of the message body.

In our work, we might be interested in helping to fund this development, if not too expensive, or if others are willing to collaborate to to co-fund the development. {sign user="xavi" datetime="2014-11-06T09:42:46+00:00"}

Related:
* "MailMerge using User Tracker & Newsletter?"
+ https://tiki.org/forumthread50890
* Get recipients list from a pretty tracker
+ http://doc.tiki.org/Newsletter+Admin#Add_emails_to_a_newsletter_from_a_list_in_a_wiki_page

Similar feature in desktop office solutions:
* https://addons.mozilla.org/en-US/thunderbird/addon/mail-merge/?src=ss
* https://support.office.com/en-gb/article/Use-mail-merge-to-send-personalized-email-messages-to-your-email-address-list-c49e5cfc-53f9-4ec8-9bd9-1f8f3648f1b7

!!# Medium: PDF generation of unique letters
* Merge data from trackers with a wiki page template and convert to PDF

!!# Advanced: Return books borrowed from a Library
This should be doable with ((doc:PluginListExecute)), new in ((Tiki11))


We want to make a mail merge for the following scenario:
http://wiki.duboue.net/index.php/LibreOfficeNLG

See also: ((Natural Language Generation))

* 1 ((doc:Tracker)) with customer info (Table Users)
* 1 tracker with books borrowed (Table Items)
* Make a query with ((doc:Reports)), ((doc:PluginList)) or ((doc:PluginCustomSearch))
* 1 wiki page for "Expected template"


Delivery: ((doc:Inter-User Messages)), ((doc:Newsletter)) or ((doc:Daily Reports))

!! Related links
* http://en.wikipedia.org/wiki/Mail_merge
* http://thankyou.reportlab.com/
* ((Natural language processing))