Unanswered: problem sending reply to email address from MSAccess
In an on click Event to send emails from a form I have to following code.
Private Sub Request_Click()
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Dim strbody As String
Dim objMyTable As Object
Dim strEmailAdds As String
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
Set objMyTable = CurrentDb.OpenRecordset("tblEmailTest")
Do While Not objMyTable.EOF
strEmailAdds = strEmailAdds & objMyTable.email & ";"
.Body = "Test."
.Subject = "Email Test"
.BCC = strEmailAdds
Set objMyTable = Nothing
Set OutMail = Nothing
Set OutApp = Nothing
The issue is with the following line of code.
This has the recipient reply to a different email than the one it was sent from. This works great if sent to an email address. Does not work if sent as a text message example email@example.com.
The text message is sent fine. The issue is that the reply from the text goes to the original sending address and not the reply to address.
One other interesting aspect is that everything works fine if it goes to an ATT phone. This leads me to believe that it is a carrier specific problem.