Guest User

Untitled

a guest
Sep 5th, 2017
661
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.10 KB | None | 0 0
  1. Const cdoSendUsingPickup = 1
  2. Const cdoSendUsingPort = 2
  3. Const cdoAnonymous = 0
  4. ' Use basic (clear-text) authentication.
  5. Const cdoBasic = 1
  6. ' Use NTLM authentication
  7. Const cdoNTLM = 2 'NTLM
  8.  
  9. Public Sub SendEmail()
  10. Dim imsg As Object
  11. Dim iconf As Object
  12. Dim flds As Object
  13. Dim schema As String
  14.  
  15. Set imsg = CreateObject("CDO.Message")
  16. Set iconf = CreateObject("CDO.Configuration")
  17. Set flds = iconf.Fields
  18.  
  19. ' send one copy with SMTP server (with autentication)
  20. schema = "http://schemas.microsoft.com/cdo/configuration/"
  21. flds.Item(schema & "sendusing") = cdoSendUsingPort
  22. flds.Item(schema & "smtpserver") = "mail.myserver.com"
  23. flds.Item(schema & "smtpserverport") = 25
  24. flds.Item(schema & "smtpauthenticate") = cdoBasic
  25. flds.Item(schema & "sendusername") = "[email protected]"
  26. flds.Item(schema & "sendpassword") = "password"
  27. flds.Item(schema & "smtpusessl") = False
  28. flds.Update
  29.  
  30. With imsg
  31. .Subject = "Test Send"
  32. .HTMLBody = "Test"
  33. '.Sender = "Sender"
  34. '.Organization = "My Company"
  35. '.ReplyTo = "[email protected]"
  36. Set .Configuration = iconf
  37. .Send
  38. End With
  39.  
  40. Set iconf = Nothing
  41. Set imsg = Nothing
  42. Set flds = Nothing
  43. End Sub
  44.  
  45. sMailServer = "myISPsmtp" 'Not just any old smtp
  46. sMailFromAddress = "me"
  47. sMailToAddress = "me"
  48.  
  49. Set ObjMessage = CreateObject("CDO.Message")
  50. sToAddress = sMailToAddress
  51. sSubject = "Subject"
  52. sBody = "MailBody"
  53.  
  54. ObjMessage.Subject = sSubject
  55. ObjMessage.From = sMailFromAddress
  56. ObjMessage.To = sToAddress
  57. 'ObjMessage.cc = sCCAddress
  58. ObjMessage.TextBody = sBody
  59. 'ObjMessage.AddAttachment sMailAttachment
  60. ObjMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
  61. ObjMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = sMailServer
  62. ObjMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
  63. ObjMessage.Configuration.Fields.Update
  64. ObjMessage.send
  65.  
  66. Sub SMPTTest2()
  67. Set emailObj = CreateObject("CDO.Message")
  68.  
  69. emailObj.From = "[email protected]"
  70. emailObj.To = "[email protected]"
  71. emailObj.Subject = "Test CDO"
  72. emailObj.TextBody = "Test CDO"
  73. 'emailObj.AddAttachment "c:windowswin.ini"
  74.  
  75. Set emailConfig = emailObj.Configuration
  76.  
  77.  
  78. emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
  79. emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
  80. emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.office365.com"
  81. 'Exclude the following line
  82. 'emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587
  83. emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
  84. emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendusername") = "[email protected]"
  85. emailConfig.Fields("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "mypassword"
  86. emailConfig.Fields.Update
  87.  
  88. emailObj.Send
  89.  
  90. If Err.Number = 0 Then MsgBox "Done"
  91. End Sub
Advertisement
Add Comment
Please, Sign In to add comment