Example 1 : A Basic Text Merge

This example uses a table called MyTeam on a MySQL server with details of names and mobile/cellphone numbers.

MyTeam table

We first create a system DSN in Data Sources (ODBC) in the control panel that connects to the MySQL server with access to the MyTeam table.

Create your System DSN

Next, in SQLSend click Open Connection and New to create a new connection. We pick our newly created ODBC entry and fill out the connection parameters.

Create a SQLSend Connection

We simply select the table to use and type in our text message.

Type your message

We can then preview all the messages to ensure the merging worked the way we wanted.

Preview your message

Finally, we click the Send Messages button and all the messages are sent over the Internet to your Service Provider and instantly onwards to the destination mobile/cellphone handsets.

Example 2 : More Advanced Merging

This example uses a table called PAYROLL in a Microsoft Access database (just for variety) that contains payment information for staff members.

Access table with pay details

We first create a system DSN in Data Sources (ODBC) in the control panel that connects to the Access database file containing the Payroll table.

Create your System DSN

Next, in SQLSend click Open Connection and New to create a new connection. We pick our newly created ODBC entry and fill out the connection parameters.

Create a SQLSend Connection

We can merge information from this table in to a payslip style message for each employee. After connecting we simply enter our message with the appropriate merge fields.

Type your message

With these merge fields we are extracting text, currency, date and time data and formatting them exactly the way we want it. The preview for the first message looks like this:

Hi Brian, you worked 24 hours this week. Your pay of £294.00 will be transferred to your account on November 30th at 10:15. Regards Accounts.

Finally, we click the Send Messages button and all the personalised messages are sent separately over the Internet and onwards to the destination mobile/cellphone handsets.

Example 3 : Sending Appointment Reminders

In this example we use Microsoft SQL Azure as the data server with a table that contains contact details and appointment times and we want to schedule text reminders to go 1 hour before each appointment.

Sql Azure table with appointment details

We first create a system DSN in Data Sources (ODBC) in the control panel that connects to the Access database file containing the Payroll table.

Sql Azure ODBC Connection

Next, in SQLSend click Open Connection and New to create a new connection. We pick our newly created ODBC entry and fill out the connection parameters. Click CONNECT to connect to the data source.

Create a SQLSend Connection

We enter the text message as normal using format modifiers to show the time portion of the table’s datetime field.

Type your message

In this example we want each message to go at a different time so we tell SQLSend to retrieve the send time from the spreadsheet itself. Here we use the appointment time and then modify the send date by 60 minutes. Therefore each message will be scheduled to be sent 1 hour before the appointment time.

Specify date and time to send

In the messages preview you can see both the message and the estimated message delivery time.

Preview the messages

Need help finding a solution?

Take a look at our buying guide, chat with us online or try out the software for free.

or download the free edition today

download

 
 
© Copyright 2018 Iflow. All Rights Reserved. Terms and Conditions | Privacy Policy