Advice is sort. I am happy about sending emails to clients, using a word document , for the content of the email, linked to a Query as the Data source .
The requirement now is send a short standard text message via SMS.textapp.net . My initial thought is to create a function. Example
#strSubject = "change of status"
strEmailAddress = rst![ClientEmail@sms.textapp.net]
ccto = ""
bccto = ""
strEMailMsg = " Client Number " & " " & rst![ClientNumber] _
& Chr(10) & " clientName " & " " & rst![ClientName] _
& Chr(10) & " " _
& Chr(10) & " The current record's status has changed to " & rst![Status]#
The above is just an example and I would like any input as to best way to achieve my objective .
Regards Ypma
I have entered this post under general, if this is misleading would a moderator move it to the appropriate section
The requirement now is send a short standard text message via SMS.textapp.net . My initial thought is to create a function. Example
#strSubject = "change of status"
strEmailAddress = rst![ClientEmail@sms.textapp.net]
ccto = ""
bccto = ""
strEMailMsg = " Client Number " & " " & rst![ClientNumber] _
& Chr(10) & " clientName " & " " & rst![ClientName] _
& Chr(10) & " " _
& Chr(10) & " The current record's status has changed to " & rst![Status]#
The above is just an example and I would like any input as to best way to achieve my objective .
Regards Ypma
I have entered this post under general, if this is misleading would a moderator move it to the appropriate section