SendHub’s MergeWiz is a small application that runs on your local browser. The MergeWiz allows you to create personalized SMS messages with data merged from a CSV formatted file and sent with one click of a button.
The MergeWiz will allow you to customize how many columns of data you use. The first column has to be the contact’s mobile phone number. If personalizing your SMS message with a name, the second column in the CSV should be used. The next columns can be any type of data, just be sure to include headers for columns 3 and 4 even if you won't be using them.
Once you type out your message you can click on the “Preview” button and it will show you the phone number, the combined message, and a character count for the first four rows of the CSV, if populated. Please be aware that your message may get segmented based on its length and character set. You can find more information about segmentation here.
Once you’re ready to send the message, click on the "Go Back" and then click on the “Send SMS”. A results window will pop-up showing how many messages were sent and if there were any errors. 
To use SendHub's MergeWiz:
To use the MergeWiz enter in your SendHub Username (the name you use to log into the SendHub application – Username is case sensitive) and your SendHub API Key.Note: You can find your SendHub API Key by clicking the cog wheel in the top right, choosing the “My Settings” menu option and then scrolling to the bottom of the My Settings page.)
The MergeWiz will allow you to customize how many columns of data you use. The first column has to be the contact’s mobile phone number. If personalizing your SMS message with a name, the second column in the CSV should be used. The next columns can be any type of data, just be sure to include headers for columns 3 and 4 even if you won't be using them.
See this sample CSV List:
The MergeWiz example will take the data based on the 2nd, 3rd, & 4th columns and parse it in between the message you type in the three message sections shown below. See the example below of a message that would be produced base on the first row of the following sample CSV.Within the MergeWiz window click on "Add Message Part" twice to add two more fields to the form. Type in the following messages in each message field.
Check out this example:
See the example below of a message that would be produced base on the first row of the sample CSV. The message above would be formatted as below based on the values in italics being pulled from the first row of the sample CSV file:"Hi John, your order number 50021325 is ready for pickup at store in Huntington Beach."
Once you type out your message you can click on the “Preview” button and it will show you the phone number, the combined message, and a character count for the first four rows of the CSV, if populated. Please be aware that your message may get segmented based on its length and character set. You can find more information about segmentation here.
Once you’re ready to send the message, click on the "Go Back" and then click on the “Send SMS”. A results window will pop-up showing how many messages were sent and if there were any errors.
Notes:
- This application uses SendHub’s API and your SendHub account has to have API access.
- Messages will be segmented based on SMS standards formats. For more information on segmentation please check out the following two links:
- The MergeWiz currently does not support sending emojis.
- The MergeWiz will work with a 10 digit or 11 digit (1 in front of the number) phone numbers. No dashes, parentheses, or spaces can be in the number.
- You can use all or skip message windows when sending messages. (If a message windows is skipped it will show the data from the CSV back to back with a space in between them.)
- All the field in the CSV file do not have to be populated. However, each column needs to have a header in order be use.