Examples of Sending SMS From Excel

Example 1 : A Basic Text Merge

Here is a very basic spreadsheet with details of names and mobile/cellphone numbers.

Prepare your spreadsheet

In ExcelSend we simply open the spreadsheet, select the Number field as the destination number 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 spreadsheet contains payment information for staff members.

Spreadsheet with pay details

We can merge information from this spreadsheet in to a payslip style message for each employee. We open the spreadsheet from ExcelSend and 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 have a spreadsheet with contact details and appointment times and we want to schedule text reminders to go 1 hour before each appointment.

Spreadsheet with appointment details

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

Type your message

In this example we want each message to go at a different time so we tell ExcelSend 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


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