Given the huge interest in the recent Google Spreadsheet TXTmerge example I thought a less intensive Microsoft Excel example might interest some people. Excel is the industry standard for desktop spreadsheets and is so powerful many people do not use 10% of what it can really do. This example uses very basic VBA to iterate through a range of data sending a TXT message for each line with the message content/template and user credentials configured on another page. It is not meant to be a full working example and has room for making it more dynamic and easy to use. It is meant to show you how simple (relatively) it is to use Excel as middle-ware to send thousands of customised TXT messages via our simple Bulletin TXT API.

Before you start you should have a basic understanding of VBA and Excel macros. Obviously you need to have excel and have macros enabled in the spreadsheet you are using. If I have lost you already or you do not know what a macro is then check out this video of a raven snow boarding. Everyone else can carry on.

The VBA code is below and can be copied and saved in a macro module of your workbook.