vikpaw - why not? The more the merrier I say :) (PS - what is our password lol?)
I wouldn't mind a copy of @pcstru 's little program. We use CMIS here and I'm sure I could tweak whatever is needed to pull out the relevant data. Any chance you could send me it? Of upload it on here whatever? Cheers
Spreadsheet attached. This will not work for anyone out of the box! You will need to provide the server and database identifiers before you can pull data from CMIS. You may need to modify the SQL if your table owners are "dbo".
There is a lot of code associated with sending SMS via the BulkSMS service (quite cheap if you buy in bulk) using the HTTP interface. Some of it is a little obscure - it's just the way it IS.
One aspect of this that makes it less flexible than it could be (i.e. just being able to modify the SQL to control selection) is the processing of data to show which of the selection will need to receive postal copies (if necessary, i.e. they have no email address or mobile phone number) and also processing to minimise postage by trying to ensure that if letters are sent, only one letter is sent to each house (in cases where muoltiple recipients live at the same address).