June 22, 2011

Copy Contact Lists Directly to SMS4PC

SMS4PC supports standard address books such as Outlook, Windows, Mac and Google. But what if your contacts aren’t in one of these formats? No worries! You can copy thousands of numbers at a time from a spreadsheet or CSV file directly to SMS4PC. Send an SMS message to hundreds, or even thousands, of users with just a few clicks.

What is a CSV?
A CSV, or comma separated values file, is simply a simplified spreadsheet, which can be opened by most spreadsheet applications. Many times, a CSV file has less formatting than an Excel file would allow, but the information is still in rows and columns. Because it is easy to convert text or data strings into CSV files, many vendors and data warehouses offer users the ability to export data into CSV. If you utilize these types of services, you may receive phone number lists in CSV format.

How to import contacts from a CSV file into the SMS application
In order to import a list of phone numbers and contacts, ensure the list is in a CSV file. You simply go to “Contacts”, “Import contacts” and select the CSV file you want to import the contacts from. After choosing the appropriate columns to import you can also define a group where the contacts and numbers shall end up.

How to Copy Phone Numbers into SMS4PC
In order to copy a list of phone numbers, ensure the list is in a spreadsheet file. If you can open the file in Excel or Open Office’s spreadsheet program, then you can copy the numbers to SMS4PC.

Once you have the data opened in a spreadsheet, identify the numbers you want to copy over. It will be easiest to do this if all the numbers are grouped together.

Put your mouse cursor over the cell with the first number. Left click and hold while you drag the mouse to cover all numbers you want to copy. Once all desired numbers are highlighted, release the left click. Right click and select copy, or use the keyboard shortcut Control-C for copy.

Go to SMS4PC and open a new message. Click in the “To” box. Use the shortcut Control-V for paste. You will note that the numbers you copied are now loaded into the SMS message. Enter the text for your message and click send.

To see more information about how to copy/paste contacts from a spreadsheet into the SMS4PC application see this video