I am using "mailto" to send sms to multiple selected people (recipient numbers + @e-mail2sms.co.za are added to cc). But I need subject to it in form of #username,password# to be able to send sms. here is part of my code. Could someone help to include subject
On Error GoTo ErrorHandler
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
Dim strHyper As String
Set db = CurrentDb
strSQL = "SELECT * FROM Students WHERE YNMail = -1;"
Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
strHyper = "mailto:firstname.lastname@example.org"
If rs.EOF Then
strHyper = strHyper & "?cc="
Do Until rs.EOF
strHyper = strHyper & rs!Cellphone & "@e-mail2sms.co.za;"