How to use custom data in outgoing messages

With Ozeki Bulk Messenger it is possible to deliver personalized information to your clients. Use data stored in your database (or in Excel files) to make each message you send unique. This feature is useful if you wish to send out information such as account balances, delivery dates or address information. Banks or any kind of telecommunication (or other) providers can use this kind of function to notify their clients.

In this guide you can see an example on how you can send customized e-mail messages using MySQL database server.

Step 1 - Create a database table

Log in to the SQL database client and create a new database table.

CREATE TABLE balance (
id int(11) NOT NULL auto_increment,
Name varchar(30) default NULL,
PhoneNumber varchar(30) default NULL,
Email varchar(30) default NULL,
Balance varchar(30) default NULL,
DueDate varchar(30) default NULL,
PRIMARY KEY (id)
) charset=utf8;
ALTER TABLE balance ADD INDEX (id) ;

create database table
Figure 1 - Create Databases table

Now it is time to insert contacts into database table.

INSERT INTO balance ( Name, PhoneNumber, Email, Balance, DueDate) VALUES
('Carl Ward', '9981954347908', 'cwd0@markwat.com', 'USD 12.024', '2016-09-30'),
('Rebecca Johnson', '625895120024', 'rjoson1@phoca.cz', 'USD 2.851', '2016-09-30'),
('Karoly Sovago', '36301234567', 'karoly.sovago@ozeki.hu', 'USD 52.874', '2016-09-30');

insert contacts into databases table
Figure 2 - Insert contacts into Databases table

Step 2 - Create a database connection

On the top of the 'Quick Start' page choose 'Setup' menu and then 'Databases' submenu.

selecting database menu
Figure 3 - Selecting 'Databases' menu

After that you will see a page where you can select which type of database you would like to add to Ozeki Bulk Messenger. Click on the 'Create new database connection' button.

creating new database connection
Figure 4 - Creating new database connection

The 'Database connection details' window will show up to the right. In this case choose 'MySQL'.

specifying the type of database server
Figure 5 - Specifying the type of the database server

Provide a name and in the 'Connection settings' window give important details of your database.

providing the connection settings
Figure 6 - Providing the connection settings

Step 3 - Create an SQL address book

Go to 'Address book' menu on the left-hand side and then click on 'Create new address book'.
In the 'Address book details' window select 'SQL'.

creating new sql addressbook
Figure 7 - Creating new SQL addressbook

In the 'General' tab you can give a name for your address book and select a previously added database connection. In the 'Query' field provide the query you wish to use for querying data from your database:

SELECT Name, PhoneNumber, Email, Balance, DueDate FROM balance

Using these keywords means that we can get the name, telephone number, email address of the contact and the balance available on the provided date from the database. Finally, we add them to the address book by clicking 'OK'.

providing the database server
Figure 8 - Providing the database server and SQL query

If the query was successful you can see that the number of your contacts have appeared in the 'Contacts' menu. Click on it in order to see more details about them.

verifying succesful connection
Figure 9 - Verifying if the connection was successful

Click on 'Open' button next to one of the contacts.

opening one of the contact
Figure 10 - Opening one of the contact

Here you will see the information which we acquired from the database. The same keyword name will be used that is the name of the column in the database table.

contact information
Figure 11 - Contact information

Step 4 - Create a message

Go to 'Messages' menu on the left and then click on 'Create new content'.
In the pop-up window you will see the possible message types. Select 'E-mail'.

creating new e-mail content
Figure 12 - Creating new 'E-mail' content

Provide a subject name and in the 'Message' field write down your message using the keywords. For example:

Dear ${Full name},

Your account balance of ${Balance} is due on ${DueDate}...
These keywords will be changed to the stored data of your contacts.

compose e-mail using keyword
Figure 13 - Compose E-mail using keywords

Step 5 - Create a new connection

Select 'Connections' on the left side and click on 'Create new connection'.
Then select 'E-mail' connection type.

creating new e-mail connection
Figure 14 - Creating new 'E-mail' connection

After that select 'Gmail' connection type if you wish to use your gmail account, or 'SMTP' connection type if you would like to use the corporate e-mail server for sending out e-mail messages.

choose gmail or smtp
Figure 15 - Choose 'Gmail' or 'SMTP' connection

If you wish to use your 'Gmail address', in the 'Gmail account' tab provide your Gmail username and the password belonging to it.

providing connection data
Figure 16 - Providing connection data

If finished click 'OK' and your setup connection will appear on the list.

available connections
Figure 17 - Available connections

Step 5 - Send your messages

Go to the 'Send' menu then click on 'Create new message delivery job'.
In the 'Job details' window you need to specify the name of the preset job, the address book, the content and the connection that you wish to use for this job. When finished, click 'Ok'.

creating a new job
Figure 18 - Creating a new job

Now select the 'Start' button in order to start the job.

starting the job
Figure 19 - Starting the job

If you have successfully started the job, the following 'Message Delivery Started' window will pop up.

messaged delivery started
Figure 20 - Message Delivery Started

Click on the 'Open' button to see the details of your delivery job. In the 'Tasks' menu and also in the 'Stats' tab you can see that the delivering process was completed and all of the messages has been sent successfully.

stats about the job
Figure 21 - Stats about the job

In your E-mail client you can see the E-mail with custom data.

e-mail with custom data
Figure 1 - E-mail with custom data

In this guide you could see an example about how you can send personalized e-mail notification to your clients. If you have any question, please send us an e-mail at info@ozeki.hu.