Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. Dim strWho As String
  2. Dim strSubject As String
  3. Dim objNewMail As Outlook.MailItem
  4.  
  5. Set objNewMail = Application.CreateItem(olMailItem)
  6.  
  7. strWho = objMail.To
  8. strSubject = objMail.Subject
  9.  
  10. With objNewMail
  11. .To = strWho
  12. .BCC = "mail2,mail3,mail4,mail5"
  13. .Subject = strSubject
  14. .Display
  15. .Send
  16. End With
  17.  
  18. "person1@email.com;person2@email.com"
  19.  
  20. Dim strWho As String
  21. Dim strSubject As String
  22. Dim objNewMail As Outlook.MailItem
  23. Dim bccMails As String
  24.  
  25. Set objNewMail = Application.CreateItem(olMailItem)
  26.  
  27. strWho = objMail.To
  28. strSubject = objMail.Subject
  29. bccMails = objMail.BCC
  30.  
  31. With objNewMail
  32. .To = strWho
  33. .BCC = bccMails
  34. .Subject = strSubject
  35. .Display
  36. .Send
  37. End With
  38.  
  39. Dim bccMails As String
  40. bccMails = InputBox("Please insert .bcc email addresses, separated by semicolons", "Email Address", "person1@email.com;person2@email.com")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement