how to trap a event coming from a dll
Ernst,
I'm guessing a bit here, but you should be able to insert a new class module into your VBA project and enter something like the
following at the top of the module:
Dim WithEvents myMailer as vbSendMail.clsSendMail
You shoud then be able to select the object and its events from the top of the module and write your event code.
--
John Green - Excel MVP
Sydney
Australia
"E.Anderegg" wrote in message ...
Hello,
I use a mailer DLL in a module.
I set the properties and then kick the Send Method. This works fine so far.
To check whether a mail was sent correctly, the dll raises the event
SendSuccessful.
How can I trap this event??
Thanks for any help
Ernst
The "simple" code for the problem
Sub SendMails()
Dim Mymailer As Object
Set Mymailer = New vbSendMail.clsSendMail
With ThisWorkbook.Worksheets("Mail")
Mymailer.SMTPHost = .Range("MailSMTPHost").Value
Mymailer.from = .Range("MailFrom").Value
Mymailer.FromDisplayName = .Range("MailfromName").Value
Mymailer.ReplyToAddress = .Range("MailReplyTo").Value
Mymailer.Recipient = .Range("TestMailRecv").Value
Mymailer.Subject = .Range("Testmailbetreff").Value
Mymailer.Message = .Range("Testmailbody").Value
End With
Mymailer.Send
Mymailer.Send
End Sub
|