hi,
my problem: i wanted to code an excel macro which sends automaticaly e-mails, and i dont want any warnings from outlook2000.
i read much about this, and i guess it is the problem that i have no chance with outlook2ks newest security update to use the sendmail function without warning.
i tried around with MAPI -> WARNING!

so can anyone help me? cause i dont want to learn toooooo much about winsock

: hi,
: my problem: i wanted to code an excel macro which sends automaticaly e-mails, and i dont want any warnings from outlook2000.
: i read much about this, and i guess it is the problem that i have no chance with outlook2ks newest security update to use the sendmail function without warning.
: i tried around with MAPI -> WARNING!
:
: so can anyone help me? cause i dont want to learn toooooo much about winsock
:
:
:

Hi, If you don't want to learn about winsock, here is little trick whitch could work..

Let MS OutLook windows (or Warning, I don't know) appear and automatically close it (in few miliseconds)

'The number 10 is time in miliseconds... TimerProc will start after this time
SetTimer Form1.hWnd, &H5000&, 10, AddressOf TimerProc
SendMailYourMail.... 

'This must be in Module
Public Sub TimerProc(ByVal hWnd_X As Long, ByVal uMsg As Long, ByVal idEvent As Long, ByVal dwTime As Long)
Dim Handle As Long
'Or anything what happens after SetTimer
'You can give here code, whitch will wait for Outlook warning 
'to make sure if you're not closing something else... 
'You can use FindWindow etc...
    SendKeys ("%s")            I don't know if there is Alt+S to send or MsgBox
    'SendKeys("{Enter}")
    KillTimer hWnd_X, idEvent
End Sub

Hope this helps...

PavlinII