Quick Links: e-Campaign   ::   FAQs Index  

FAQs:: Creating Mailing Lists

1. How do I create a mailing list?
2. How do I use Microsoft Excel/Access files?
3. How do I remove duplicate email addresses?
4. How do I export addresses from Microsoft Outlook?
5. How do I connect to MySQL databases?

 

How do I create a mailing list?

e-Campaign mailing list software supports plain-text mailing lists delimited by commas, tabs, or semicolons.

You can create your mailing lists using a plain text editor, such as Windows Notepad. A simple (one-column) mailing list may look like this:

Email
a@x.com
b@x.com
c@y.com

The above mailing list contains only one column (the "Email" column). The first line is the header of the mailing list. Rows containing incomplete email addresses are ignored.

A mailing list can have as many columns as you want, with each column separated by a delimiter(comma, tab, or semicolon):

FirstName, LastName, Email
Joe, Smith, joe@xxx.com
Matt, White, matt@yyy.com

When you specify a mailing list for a mailing job, e-Campaign lets you choose the delimiter character and which column contains the email addresses.

---

How do I use Microsoft Excel/Access files?

To use a Microsoft Access or Excel file (*.xls), you need to first create a "Database Connection".

Step 1: Create a database connection so that e-Campaign can connect to Access databases/Excel spreadsheets. Click the "Database" toolbar icon to proceed. On the "Database Connection" window, click the "Use MS Access/Excel File" button to specify a Excel file. Press F1 for more detailed explanation on database connections.

Step 2: Create a mailing job

Step 3: On the Message Composer, click menu "Mailing List->Database Connections" and select the database connection you created in Step 1

---

How do I remove duplicate email addresses?

You can use the utility ListTool to remove duplicates from plain-text mailing list files. It's available under menu Help-> Misc Tools

---

How do I export addresses from Microsoft Outlook?

In Outlook 2010 or older, click menu File -> Import and Export..., select the option "Export to a file".

In Outlook 2013 or newer, click at the "File" tab, click at "Open & Export", then click at "Import/Export".

Select "Comma Separated Values"

Select the "Contacts" folder

---

How do I connect to MySQL databases?

To connect to MySQL databases via ADO/ODBC, you need MySQL Connector/ODBC 5.1 (or later) installed. Please install the database drivers at:
http://dev.mysql.com/downloads/connector/odbc/

Connection String used to connect to MySQL:

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

 

 

e-Campaign FAQs Index      General Questions     |     Creating Mailing Lists     |     Mail Merge: Sending Personalized Emails         Email Delivery Problems     |     Creating Rich-Text Email Messages     |     Mailing Job Management