location: Diff for "email/mailMerge"

Institute of Mathematics - PublicMathWiki:

Differences between revisions 3 and 11 (spanning 8 versions)
⇤ ← Revision 3 as of 2011-09-01 15:57:01 →
Size: 2781
Editor: crose
Comment:
← Revision 11 as of 2021-02-02 15:58:16 → ⇥
Size: 3038
Editor: eseide
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:

* Sending mass mail via Thunderbird with the add-on [[https://addons.mozilla.org/de/thunderbird/addon/mail-merge/|Mail Merge]] (already installed on Sun Ray)
 * Database is a CSV File		  * Sending mass mail via Thunderbird with the add-on [[https://addons.mozilla.org/de/thunderbird/addon/mail-merge/|Mail Merge]] (already installed on the terminal servers).
 * Database is a CSV File.
Line 8: Line 7:
 2. Start to write the Mail. As receiver (field '''To''') write `{{email}}`.
 3. Inside of the 'new mail'-window, 
  * click on menu: `File > Mail Merge`. 		  1. Start to write the Mail. As receiver (field '''To''') write `{{email}}`.
 1. Inside of the 'new mail'-window,
  * click on menu: `File > Mail Merge`.
Line 15: Line 14:
   * Click '''OK'''.     * Click '''OK'''.
Line 19: Line 18:
 4. You'll find a copy of each mail in your send folder.  1. You'll find a copy of each mail in your send folder.
Line 25: Line 24:
 * Format Rules:{{{  * Format Rules:
 {{{
Line 35: Line 35:
 * Example {{{  * Example CSV File:
 {{{
Line 40: Line 41:
Line 45: Line 47:
 * If necessary, insert further variable names (folumn names in the CSV file)  * If necessary, insert further variable names (column names in the CSV file - no spaces in column names!).
Line 47: Line 50:
 * Finish: Menu `File > Mail Merge`
 * Optional: Save this mail (for later use) as a draft.
 * Finish: Menu `File > Mail Merge`.
Line 52: Line 58:
Line 56: Line 63:
 * Click '''OK'''.   * Click '''OK'''.
Line 60: Line 67:
== Sendind Mails ==
 * Click on `File > Send unsent messages`		 == Sending Mails ==
Mails:

 * OK: Click on `File > Send unsent messages`
 * Bad: delete all mails of the folder 'Outbox' and start again with writing the mail or use the previously saved draft.
Line 64: Line 74:
 * You'll find a copy of each mail in your send folder.  * You'll find a copy of each mail in your sent folder.

Mail Merge: sending mass mail via Thunderbird

  • Sending mass mail via Thunderbird with the add-on Mail Merge (already installed on the terminal servers).

  • Database is a CSV File.

Quick Intro

  1. Create a receiver list as CSV File

  2. Start to write the Mail. As receiver (field To) write {{email}}.

  3. Inside of the 'new mail'-window,

    • click on menu: File > Mail Merge.

      • Choose: Personal Mail

      • Deliver Mode: Send Later

      • Format: Plain Text

      • Browse and select the CSV File (step 1) with all the receiver email addresses.

      • Click OK.

    • The 'new mail' window disappears.

    • All mails will be generated and copied to Local Folders > Outbox. Here you can check the mails.

    • To send all mails, click on File > Send unsent messages

  4. You'll find a copy of each mail in your send folder.

Detailed description

CSV file with receiver email addresses

  • Create a CSV file (plain text file with "," as field separation). One line for each receiver.

  • Use a generic Texteditor like gedit or nedit.

  • Format Rules: 
    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
  • Example CSV File: 
    email,individual,name,title
albert.einstein@heaven.org,blue,Einstein,Prof.
nelson.mandela@freedom.sa,peace,Mandela,Mr.

mailmerge.04.png

Write Mail

  • Write the mail as you would normally do.

  • In the To field insert the name of the column of the CSV file which represents the receiver email address.

  • If necessary, insert further variable names (column names in the CSV file - no spaces in column names!).

mailmerge.02.png

  • Optional: Save this mail (for later use) as a draft.

  • Finish: Menu File > Mail Merge.

mailmerge.03.png

Mail Merge

mailmerge.01.png

  • Choose: Personal Mail

  • Deliver Mode: Send Later

  • Format: Plain Text

  • Browse and select the CSV File (step 1) with all the receiver email addresses.

  • Click OK.

  • The 'new mail' window disappears.

  • All mails will be generated and copied to Local Folders > Outbox. Here you can check the mails.

Sending Mails

Mails:

  • OK: Click on File > Send unsent messages

  • Bad: delete all mails of the folder 'Outbox' and start again with writing the mail or use the previously saved draft.

Final

  • You'll find a copy of each mail in your sent folder.

PublicMathWiki: email/mailMerge (last edited 2021-02-02 15:58:16 by eseide)