Thanks for your prompt response. The recordset is similar to this very one in the vba code you sent. Can you once again help on how i can construct and send the message within the lop using vba codes since am not good in that. Thanks in advance
Hello, am back again with another follow up question. Sending the same message to different contacts has been achieved. The new problem is, how can i personalized the message to send to their respective recipients.
For instance, in sending the message, i would like the vba code to auto insert...
Its working.
But the displayed contacts always ends with comma (,)
Also, if no contacts are selected and you run it, it returns run-time error '5'
How do i correct these two problems
I am trying to build an MS Access database that can be used to send bulksms.
The problem am facing has to do with how the recipient textbox (ttcontact) on a form can be populated with phone numbers (separated with commas) when they are checked in checkboxes.
I researched a little and was able...
Am emma from Ghana. I am a not an expert in access even though i have been using it to design some few database programmes. I hope to learn from my gurus here