location: Diff for "email/mailMerge"

Institute of Mathematics - PublicMathWiki:

Differences between revisions 1 and 2
Revision 1 as of 2011-09-01 15:29:01
Size: 783
Editor: crose
Comment:
Revision 2 as of 2011-09-01 15:55:28
Size: 2754
Editor: crose
Comment:
Deletions are marked like this. Additions are marked like this.
Line 9: Line 9:
 3. Inside of the new mail,
  * click on menu: `File > Personal Mail`.
  * You will be asked about the CSV file (receiver list). '''Browse''' for it, click '''OK'''.
 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'''.
Line 13: Line 17:
  * All mails will be generated and copied to `Local Folders > Outbox`.   * All mails will be generated and copied to `Local Folders > Outbox`. Here you can check the mails.
Line 16: Line 20:

= Detailed description =
== CSV file with receiver email addresses ==
 * Create a CSV file (plain text file with "," as field separation).
 * 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 {{{
email,individual,name,title
albert.einstein@heaven.org,blue,Einstein,Prof.
nelson.mandela@freedom.sa,peace,Mandela,Mr.
}}}
{{attachment: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 (folumn names in the CSV file)
{{attachment:mailmerge.02.png}}
 * Finish: Menu `File > Mail Merge`
{{attachment:mailmerge.03.png}}

== Mail Merge ==
{{attachment: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.

== Sendind Mails ==
 * Click on `File > Send unsent messages`

= Final =
 * You'll find a copy of each mail in your send folder.

Mail Merge: sending mass mail via Thunderbird

  • Sending mass mail via Thunderbird with the add-on Mail Merge (already installed on Sun Ray)

  • 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).
  • 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

    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 (folumn names in the CSV file)

mailmerge.02.png

  • 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.

== Sendind Mails ==

  • Click on File > Send unsent messages

Final

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

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