Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Overview
Required Permissions
Admin
How to set up an XME list (Mailing Lists)
Open Excel file
Make sure the document is formatted correctly
Exactly three columns
Must be in the following order:
Column 1: First Name
Column 2: Last Name
Column 3: Email
Note: Each contact needs a unique email address.
...
Remove title row
These are column descriptors – usually “First Name”, “Last Name”, “Email”
**This document should contain only data
Cannot use multiple sheets.
Separate sheets into their own book
Right click sheet tab
Sheet tab is located at the bottom of the window
Click “Move or Copy…”
From the “To book:” drop down, select “(new book)”
Format
See steps 2a through 2d
Convert to a .csv
File>Save As
In the “Save as type” dropdown, select “CSV (Comma delimited)”
Hit Save
Make sure your filename does not contain decimals (.)
Tip: use underscore (_) to separate information within a filename
You may see a pop up…
“List [ FILENAME] may contain features that are not compatible with CSV (comma delimited). Do you want to keep the workbook in this format?”
Click “yes”
...
Add .csv to the External Marketing Emailer (XME)
Log-in to your website
Locate the Admin Dashboard
(grey bar across the top of your website)
Hover over the “Admin” tab
Located on the far left side of the Admin Dashboard
Click
...
“Groups”
...
Click the “Lists” tab
Location: furthest tab to the right
Click
...
“Add List”
Enter a name for the list.
Optional:
Add a description:
This will appear next to your list to give you more information.
Allow Opt In/Out
Allows those in the list to opt in or out of the list. It’s checked by default.
Click “Create List”
...
The following dialogue will appear:
“Your List has been saved”
Click “Click here to continue.”
...
Click
...
...
...
Click “Choose File”
Add your email to the text box…
“Upon Completion, Send Import Report Email to”
Select Import Type
2 options:
“Merge File with Existing Contacts”
This grows your list. It will merge duplicate contacts. It will never delete.
“Replace Contacts on this List with only Contacts in File”
Only the contacts from the .csv you are importing will be housed in the list.
Click “Import”
...
Click okay on the dialogue box
“The upload was successful. An email will be sent to the specified address once your import is complete.”
...
Wait for upload email notification.
NOTE: If you did not enter an email address (step 4L) you will not receive an email. You will have to come directly back to the Lists tab (step 4e) and view your group.