Hi, everyone!
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
Code:
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)
rs.MoveFirst
strHyper = "mailto:myname@gmail.com"
If rs.EOF Then
GoTo runHyper
Else
strHyper = strHyper & "?cc="
End If
Do Until rs.EOF
strHyper = strHyper & rs!Cellphone & "@e-mail2sms.co.za;"
rs.MoveNext
Loop