Recipient sources

JungleMail for Office 365 provides several recipient sources to send your newsletters to. In this tutorial, we'll overview each source and its unique differences.

Selecting a recipient source

1. Open the app and select Create Newsletter in the dashboard or in the top menu.

2. In the Recipient source section, select one of the six available sources.

SharePoint list

Click Browse to select the SharePoint list containing your recipients. Then, check if the Recipient column points to the column with email addresses.

Office 365, AD Groups

Having selected this recipient source, you will be able to send newsletters to all Office 365 group types:

Office 365 groups
Distribution groups
Security groups
Mail-enabled security groups

Before you can send to those groups, you need to enable Azure Active Directory connection. Click on the Select groups... field to open the list of available Office 365 groups or start typing to get suggestions. When sending emails to a user group, JungleMail for Office 365 will recursively expand selected groups and send a personalized newsletter for each group member.

Exchange groups

Having selected this recipient source, you will be able to send newsletters to groups supported by Exchange Web Services (EWS):

Dynamic distribution groups
Office 365 groups
Distribution groups
Mail-enabled security groups

Before you can send to those groups, you need to enable Microsoft Exchange Connection (Enterprise package feature). When sending emails to a group, JungleMail for Office 365 will recursively expand selected groups and send a personalized newsletter for each group member.

Email addresses

This is the default recipient source. In the Email addresses field, enter the recipients' addresses separated by a comma or in a new line for each recipient. If you want to use the recipient's name for personalization, add it before the address which has to be enclosed by angle brackets (see example above).

This recipient source supports group email addresses, too. However, in this case, JungleMail for Office 365 considers the group email address as a single recipient, which distorts analytics and severely limits content personalization options. Therefore, we do not recommend to use this recipient source for newsletters aimed at any type of distribution list. Read on to learn more.

File

JungleMail can automatically parse files, extract email addresses and use all columns for placeholders (mail merge). Supports file extensions: .csv, .txt, .xlsx, .xlsm, .xltx, .xltm

Supports formats:

Comma delimited CSV file (.csv);
Tab delimited TXT file (.txt);
Excel 2007+ files (.xlsx, .xlsm, .xltx, .xltm).

Total file size default limit: 10 MB

Parsing rules:

JungleMail reads only the first Excel worksheet.
It automatically detects header row and email address column by looking for valid email address in the first two data rows.
If email address is found in the first row, it means that file does not have header and column names will be generated automatically, e.g. Column A, Column B, Column C, …
If second row contains an email address, it means that the first row is a header row and column names will be taken from it. Suffix will be appended to duplicate column names. Unnamed columns will be automatically named, e.g. Column E, Column F, …
There must be at least one email address in the first two data rows, otherwise file parsing is impossible and JungleMail will show an error.

Previous newsletter

This option allows you to pick recipients from past newsletters.

Sent - All recipients that the newsletter was sent to.

Opened - All recipients that opened the previous newsletter.

Unopened - All recipients that did not open the previous newsletter.

Clicked - All recipients that clicked at least one link from the previous newsletter.

Not Clicked - All recipients that did not click any links from the previous newsletter.

Selecting the right source for group email addresses

A relatively common scenario we observe in JungleMail for Office 365 usage is selecting the Email addresses source and then entering the email address of a distribution group (list). Although the app will send a newsletter to all recipients in the group, there are a couple of important benefits that you will miss in such a configuration.

If you want to send to a group email address and you select Email addresses as a recipient source:

Features related to targeted content retrieval, such as Cascading Dynamic Content or mail merging - will not work.
Section Visibility - another feature dependent on metadata - will not work properly.
You will not be able to see in advance the number of recipients and emails that will be sent. Instead, JungleMail for Office 365 will count the whole group as 1 recipient.
Analytics reports, too, will be inaccurate: all the opens and clicks will be attributed to 1 user (group email address).
If any recipient in the group opts to unsubscribe from the newsletter, the whole group will be unsubscribed.

To avoid the issues listed above, if you are sending to a group email address, we highly recommend selecting either Office 365, AD groups or Exchange groups as a recipient source.