<?xml version="1.0" encoding="utf-8"?><!DOCTYPE article  PUBLIC '-//OASIS//DTD DocBook XML V4.4//EN'  'http://www.docbook.org/xml/4.4/docbookx.dtd'><article><articleinfo><title>email/mailMerge</title><revhistory><revision><revnumber>11</revnumber><date>2021-02-02 15:58:16</date><authorinitials>eseide</authorinitials></revision><revision><revnumber>10</revnumber><date>2013-05-10 15:01:31</date><authorinitials>crose</authorinitials></revision><revision><revnumber>9</revnumber><date>2013-04-25 13:58:38</date><authorinitials>frankm</authorinitials></revision><revision><revnumber>8</revnumber><date>2011-09-01 16:18:26</date><authorinitials>crose</authorinitials></revision><revision><revnumber>7</revnumber><date>2011-09-01 16:06:24</date><authorinitials>crose</authorinitials></revision><revision><revnumber>6</revnumber><date>2011-09-01 15:59:11</date><authorinitials>crose</authorinitials></revision><revision><revnumber>5</revnumber><date>2011-09-01 15:58:17</date><authorinitials>crose</authorinitials></revision><revision><revnumber>4</revnumber><date>2011-09-01 15:57:20</date><authorinitials>crose</authorinitials></revision><revision><revnumber>3</revnumber><date>2011-09-01 15:57:01</date><authorinitials>crose</authorinitials></revision><revision><revnumber>2</revnumber><date>2011-09-01 15:55:28</date><authorinitials>crose</authorinitials></revision><revision><revnumber>1</revnumber><date>2011-09-01 15:29:01</date><authorinitials>crose</authorinitials></revision></revhistory></articleinfo><section><title>Mail Merge: sending mass mail via Thunderbird</title><itemizedlist><listitem><para>Sending mass mail via Thunderbird with the add-on <ulink url="https://addons.mozilla.org/de/thunderbird/addon/mail-merge/">Mail Merge</ulink> (already installed on the terminal servers). </para></listitem><listitem><para>Database is a CSV File. </para></listitem></itemizedlist></section><section><title>Quick Intro</title><orderedlist numeration="arabic"><listitem><para>Create a receiver list as CSV File </para></listitem><listitem><para>Start to write the Mail. As receiver (field <emphasis role="strong">To</emphasis>) write <code>{{email}}</code>. </para></listitem><listitem><para>Inside of the 'new mail'-window, </para><itemizedlist><listitem><para>click on menu: <code>File &gt; Mail Merge</code>. </para><itemizedlist><listitem><para>Choose: <emphasis role="strong">Personal Mail</emphasis> </para></listitem><listitem><para>Deliver Mode: <emphasis role="strong">Send Later</emphasis> </para></listitem><listitem><para>Format: <emphasis role="strong">Plain Text</emphasis> </para></listitem><listitem><para><emphasis role="strong">Browse</emphasis> and select the CSV File (step 1) with all the receiver email addresses. </para></listitem><listitem><para>Click <emphasis role="strong">OK</emphasis>. </para></listitem></itemizedlist></listitem><listitem><para>The 'new mail' window disappears. </para></listitem><listitem><para>All mails will be generated and copied to <code>Local Folders &gt; Outbox</code>. Here you can check the mails. </para></listitem><listitem><para>To send all mails, click on <code>File &gt; Send unsent messages</code> </para></listitem></itemizedlist></listitem><listitem><para>You'll find a copy of each mail in your send folder. </para></listitem></orderedlist></section><section><title>Detailed description</title><section><title>CSV file with receiver email addresses</title><itemizedlist><listitem><para>Create a CSV file (plain text file with &quot;,&quot; as field separation). One line for each receiver. </para></listitem><listitem><para>Use a generic Texteditor like <code>gedit</code> or <code>nedit</code>. </para></listitem><listitem><para>Format Rules: </para><screen><![CDATA[records are separated by line breaks (\r, \n, \r\n)
fields are separated by field delimiters (comma, semicolon, colon, tab)
fields may be enclosed within text delimiters (double quote, single quote, none)
fields with embedded line breaks must be enclosed within text delimiters
fields with embedded field delimiters must be enclosed within text delimiters
fields with embedded text delimiters must be enclosed within text delimiters
embedded text delimiters must be doubled
first record must contain columnnames]]></screen></listitem><listitem><para>Example CSV File: </para><screen><![CDATA[email,individual,name,title
albert.einstein@heaven.org,blue,Einstein,Prof.
nelson.mandela@freedom.sa,peace,Mandela,Mr.]]></screen></listitem></itemizedlist><para><inlinemediaobject><imageobject><imagedata fileref="https://wiki.math.uzh.ch/public/email/mailMerge?action=AttachFile&amp;do=get&amp;target=mailmerge.04.png"/></imageobject><textobject><phrase>mailmerge.04.png</phrase></textobject></inlinemediaobject> </para></section><section><title>Write Mail</title><itemizedlist><listitem><para>Write the mail as you would normally do. </para></listitem><listitem><para>In the <code>To</code> field insert the name of the column of the CSV file which represents the receiver email address. </para></listitem><listitem><para>If necessary, insert further variable names (column names in the CSV file - no spaces in column names!). </para></listitem></itemizedlist><para><inlinemediaobject><imageobject><imagedata fileref="https://wiki.math.uzh.ch/public/email/mailMerge?action=AttachFile&amp;do=get&amp;target=mailmerge.02.png"/></imageobject><textobject><phrase>mailmerge.02.png</phrase></textobject></inlinemediaobject> </para><itemizedlist><listitem><para>Optional: Save this mail (for later use) as a draft. </para></listitem><listitem><para>Finish: Menu <code>File &gt; Mail Merge</code>. </para></listitem></itemizedlist><para><inlinemediaobject><imageobject><imagedata fileref="https://wiki.math.uzh.ch/public/email/mailMerge?action=AttachFile&amp;do=get&amp;target=mailmerge.03.png"/></imageobject><textobject><phrase>mailmerge.03.png</phrase></textobject></inlinemediaobject> </para></section><section><title>Mail Merge</title><para><inlinemediaobject><imageobject><imagedata fileref="https://wiki.math.uzh.ch/public/email/mailMerge?action=AttachFile&amp;do=get&amp;target=mailmerge.01.png"/></imageobject><textobject><phrase>mailmerge.01.png</phrase></textobject></inlinemediaobject> </para><itemizedlist><listitem><para>Choose: <emphasis role="strong">Personal Mail</emphasis> </para></listitem><listitem><para>Deliver Mode: <emphasis role="strong">Send Later</emphasis> </para></listitem><listitem><para>Format: <emphasis role="strong">Plain Text</emphasis> </para></listitem><listitem><para><emphasis role="strong">Browse</emphasis> and select the CSV File (step 1) with all the receiver email addresses. </para></listitem><listitem><para>Click <emphasis role="strong">OK</emphasis>. </para></listitem><listitem><para>The 'new mail' window disappears. </para></listitem><listitem><para>All mails will be generated and copied to <code>Local Folders &gt; Outbox</code>. Here you can check the mails. </para></listitem></itemizedlist></section><section><title>Sending Mails</title><para>Mails: </para><itemizedlist><listitem><para>OK: Click on <code>File &gt; Send unsent messages</code> </para></listitem><listitem><para>Bad: delete all mails of the folder 'Outbox' and start again with writing the mail or use the previously saved draft. </para></listitem></itemizedlist></section></section><section><title>Final</title><itemizedlist><listitem><para>You'll find a copy of each mail in your sent folder. </para></listitem></itemizedlist></section></article>