» Extract name and email address from Text Message autoresponses using Excel

When using a text message response mechanic it is often good to ask for a name and an email address in the response as well. As the data of the incoming message all comes in in one field it is often a time consuming process to extract the name and email address.

We have built a nifty little Excel worksheet which takes care of this. Download the file here.

INSTRUCTIONS:

When promoting your campaign, it is important to ask people to text in in a specific way which is:
[KEYWORD] space [FIRSTNAMEONLY] space [EMAILADDRESS]

Then, once all the autoresponses are in simply copy and paste them into the yellow part of column A of the Excel sheet. It will remove the keyword and split out the name and email address into separate columns for easier importing into other applications.

Paste your autoresponse data into the yellow section to strip out the name and email address. Handles up to 10,000 records at a time.

Popularity: 17%

Related posts:

1. System Update – Upload your mobile numbers straight from Microsoft Excel
   The development team at Text Marketer have had a busy few months and the latest system improvement has now been...
2. Creating a message and saving it to the Message Library
   Writing a message and saving it to the message library Your account has a message library that allows you to...
3. How to use the Text Marketer Text Response system Using Short Code 88802
   Introduction This article explains how to use the incoming text feature or shortcode SMS part of your Text Marketer account....
4. How to create an Email to SMS Gateway
   This document explains how you can use postfix to call a script, with the result that you can then interface...
5. How to send a Personalised / Merge Text Message
   This article shows you how to use the merge function in our text messaging application. This is useful when you want...
6. Concatenated “Long Message” SMS feature now Live for the Bulk SMS system and the SMS Gateway
   You can now send text messages longer than 160 characters, in fact up to 612 characters which arrive as 1...
7. Upload a list of mobile numbers to a group
   This article shows you how to upload a simple mobile number list with no other data fields. For help on...
8. Free Unsubscribe Service Now Available for All Customers
   The Mobile Marketing Association best practive guidelines state that you need to have an unsubscribe service so that customers who...
9. Amey Enforce Safe Driving Message With Text Campaign
   Leading public service provider Amey, has come up with a cunning idea to make sure that its team of field...
10. Text Marketer short code / txtUs API options
    Introduction The keyword on your system (on short code 88802) or your txtUs number can be used to “route” incoming...