Email

[Beeyen]

There a way to setup a email command, coded to open lotus notes mail and open
with the selected names from combo box 1 and 2 (names that are in the lotus
notes global address book) populate into the To: field and another combo box
(3) into the From: field and link the body of the email with another field in
the main form?

Combo Box one: SELECT tblBenefitsEmployee.EmployeeID,
tblBenefitsEmployee.LastName & ", " & [FirstName] AS Expr1 FROM
tblBenefitsEmployee ORDER BY tblBenefitsEmployee.LastName & ", " &
[FirstName], tblBenefitsEmployee.FirstName WITH OWNERACCESS OPTION;

Combo Box two: SELECT tblBenefitsEmployee.EmployeeID,
tblBenefitsEmployee.LastName & ", " & [FirstName] AS Expr1 FROM
tblBenefitsEmployee ORDER BY tblBenefitsEmployee.LastName & ", " &
[FirstName], tblBenefitsEmployee.FirstName WITH OWNERACCESS OPTION;

Combo Box three: SELECT tblRouter.RouterID, tblRouter.LastName & ", " &
[FirstName] AS Expr1, tblRouter.FirstName FROM tblRouter ORDER BY
tblRouter.LastName & ", " & [FirstName];

Thanks for any help you can provide

 

[Arvin Meyer MVP]

Not that I know of. If you have the email addresses in a combo box column,
you can make it work by choosing the column (+1 because it's zero based),
you can get what you want.

something like:

NotesMailDoc.SaveMessageOnSend = True
NotesMailDoc.SendTo = Me.cboOne.Column(4)
NotesMailDoc.from = NotesSession.UserName
NotesMailDoc.Subject = "Test mail"
NotesMailDoc.Body = Me.txtMsg
NotesMailDoc.Send