Guest User

Untitled

a guest
May 11th, 2019
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  2. 'Diese Funktion verschickt eine Email ohne Outlook
  3. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  4. 'Verwendung:''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  5. 'SmtpServer: Der SMTP Server, der die Email versendet. Beispiel: "smtp.gmail.com"
  6. 'Username: Benutzername des Email Accounts, wovon die Email versendet wird.
  7. 'Password: Passwort des Email Accounts, wovon die Email versendet wird.
  8. 'Betreff: Betreff der Email
  9. 'Nachricht: Nachricht der Email
  10. 'ZielAdresse: Die Email Adresse, wohin die Email versendet wird.
  11. '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
  12. Private Sub SendEmail(SmtpServer As String, Username As String, Password As String, Betreff As String, Nachricht As String, ZielAdresse As String)
  13.     Dim Mail As New Message
  14.     Dim Config As Configuration
  15.     Set Config = Mail.Configuration
  16.    
  17.     Config(cdoSendUsingMethod) = cdoSendUsingPort
  18.     Config(cdoSMTPServer) = SmtpServer
  19.     Config(cdoSMTPServerPort) = 25
  20.     Config(cdoSMTPAuthenticate) = cdoBasic
  21.     Config(cdoSMTPUseSSL) = True
  22.     Config(cdoSendUserName) = Username
  23.     Config(cdoSendPassword) = Password
  24.     Config.Fields.Update
  25.    
  26.     Mail.To = ZielAdresse
  27.     Mail.From = Config(cdoSendUserName)
  28.     Mail.Subject = Betreff
  29.     Mail.HTMLBody = Nachricht
  30.     Mail.Send
  31.    
  32.     If Err.Number <> 0 Then
  33.         MsgBox "Fehler beim Versenden der Email"
  34.         Exit Sub
  35.     End If
  36.    
  37. End Sub
Add Comment
Please, Sign In to add comment