File Format

Introduction to File Format


jMailerPro only accepts CSV (comma delimited) formatted files. CSV are "Common Separated Values" the "comma delimited" part means that the "common separator" is a comma. CSV files are plain-text files with columns separated by commas and rows separated by line-feeds.

Below is a sample of data formated in CSV (comma delimited)
Example
first,last,email,phone,ip
John,Doe,john@example.com,555-555-1234,127.0.0.1

The title row

A title row in your CSV is highly recommended. See the example below:
Example
first,last,email,phone,ip
John,Doe,john@example.com,555-555-1234,127.0.0.1

The first line describes the contents of each column. The following line shows a record of data in the same order as its label. The first row, our "title row," will allow jMailerPro to replaces special tags in your e-mail with the recipients information.

For Example, If you loaded the example file above into jMailerPro, you could use the following message:
Example
Hi %first%!

Just wanted to let you know about the new updates to my new website. I tried to call you but you didn't answer. Is your phone number still %phone%?

When John Doe receives his e-mail, it will read.
Hi John!

Just wanted to let you know about the new updates to my new website. I tried to call you but you didn't answer. Is your phone number still 555-555-1234?


Back to top.


Exporting from Excel

If you have your list in Excel (xls or xlsx formats) you will need to click on "File" in the menubar and select "Save As.."  and select "CSV (comma delimited)" from the "File Type" dropdown.

Here is a more detailed tutorial: http://office.microsoft.com/en-us/excel-help/import-or-export-text-txt-or-csv-files-HP010099725.aspx#BMexport

Back to top.


Free Editing Software

Different operating systems need different tools to format lists correctly, but we highly suggest CSVed for Windows.


Back to top.



















Close This