form?

[raven123]

If a person chooses 1,2,3 from the hot list AND the prior hot list was not one of these values then
I want to send out an email.

How would I go about doing something like this??? :-)

[HeSaidJoe]

'launch default email program and send mail

Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, _
ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long

Private Const SW_SHOW = 5
    
'form code
'if whatever <> whatever then
ShellExecute hwnd, "open", "mailto:[email protected]", vbNullString, vbNullString, SW_SHOW
'endif