Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trap show toolbar event | Links and Linking in Excel | |||
how can I trap the change event (Tab Press key) of these controls | Excel Worksheet Functions | |||
how can I trap the change event (Tab Press key) of these controls | Excel Worksheet Functions | |||
Trap Excel events from VB | Excel Programming |