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??? :-)
Printable View
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??? :-)
Code:'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