Sending Text Messages from Access

[dferreira]

I ran into an issue when sending a text message in Access.

I have T-Mobile and the suffix is correct. I have another user who has Verizon. I am sending some fields based on a form in access as a text message. I am getting all of the fields in my text message, but the Verizon user is not getting all of the fields. He is getting the text message. But not all fields. This is strange.

Does anyone have any ideas?

Donna

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...access.322200/

[CJ_London]

Think this is a question for whoever you have supply the sms functionality .

[dferreira]

I have used this code before for doing sms text messages. I am just doing the following code:

Dim O As Object 'Outlook Application
Dim M As Object 'Outlook MailItem

Set O = CreateObject("Outlook.Application")
Set M = O.CreateItem(0)

With M
.BodyFormat = 1 'Plain Text
.Body = vbCrLf & vbCrLf & Me.Transport_Reason.Column(1) & vbCrLf & vbCrLf & "Pickup:" & " " & Me.Req_FAC.Column(1) & "," & " " & Me.Room__ & _
vbCrLf & vbCrLf & Me.FAC_Add & _
vbCrLf & vbCrLf & "Pickup Requested:" & " " & Me.ReqTime & _
vbCrLf & vbCrLf & "PT:" & " " & Me.Patient.Column(1) & _
vbCrLf & vbCrLf & "DOB:" & " " & Me.Patient_DOB & _
vbCrLf & vbCrLf & "WT:" & " " & Me.Patient_WT & _
vbCrLf & vbCrLf & "DEST:" & " " & Me.Destination.Column(1) & _
vbCrLf & vbCrLf & Me.Dest_Address




.To = Me.cboPhone.Column(1) & Me.cboPhone.Column(3)
'Phone & CarrierCombo.Column(2)
.Subject = "New Call"

.Display
End With

Set M = Nothing
Set O = Nothing

When I used this same code before there was no issues. The only difference is that there are more fields to display in this text message. The other difference is that I have an android phone and the other user has an Iphone 11. It is as though, the Iphone can only take so many lines of text.

I would appreciate if you can think of any thing else.

Donna

[Welshgasman]

https://www.google.com/search?q=max+...hrome&ie=UTF-8

[CJ_London]

support for sms from outlook ended some years ago (with 2010 I think) and I thought had been disabled from 2013 although I believe there is a workaround. Since you are sending (i presume) the full message since you receive it via T mobile, the issue is with the receipt, which be will be with whatever carrier the recipient is using (Verizon?) or perhaps whatever service you are using to process the message

[dferreira]

Another question. Is there a way to send encrypted imessages from Access?

[CJ_London]

not so far as I am aware - perhaps use whatsapp which has end to end encryption

https://www.whatsapp.com/business/api
https://whatsmate.github.io/2017-02-...p-message-vba/