B
Beeyen
Good Day,
I am using the SendObject coding below to create an email in Access.
I am trying to figure out how to link a field with a control source called
DataTRAKNUMBER in the Subject line along with the message Production
Assigned?
Also, I have two combo boxes Production Assigned and QandALead which have
drop downs with names of users that are listed in the Global Network Address
book; Is there a way to automatically find the names selected in the combo
box, by way of the Global Address book and be added to the To line?
To: Combo Box selection in Production Assigned
Combo Box selection in QandALead
Subject: DataTRAKNUMBER (from the field link)
Thank you for any assistance you can provide.
Dim LResponse As Integer
LResponse = MsgBox("Do you wish to continue?", vbYesNo, "Continue")
If LResponse = vbYes Then
DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)", , , " Production
Assigned",
Else
Exit Sub
End If
End Sub
I am using the SendObject coding below to create an email in Access.
I am trying to figure out how to link a field with a control source called
DataTRAKNUMBER in the Subject line along with the message Production
Assigned?
Also, I have two combo boxes Production Assigned and QandALead which have
drop downs with names of users that are listed in the Global Network Address
book; Is there a way to automatically find the names selected in the combo
box, by way of the Global Address book and be added to the To line?
To: Combo Box selection in Production Assigned
Combo Box selection in QandALead
Subject: DataTRAKNUMBER (from the field link)
Thank you for any assistance you can provide.
Dim LResponse As Integer
LResponse = MsgBox("Do you wish to continue?", vbYesNo, "Continue")
If LResponse = vbYes Then
DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)", , , " Production
Assigned",
Else
Exit Sub
End If
End Sub