SendObject and combo boxes

[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

 

[Mr. B]

Beeyen,

First, you will need to use send your email using CDo/Outlook if you want to
be able to provide the additional information in the email.

Check this link. It should help you do what you want to do.

http://www.mvps.org/access/modules/mdl0019.htm

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm