How to send mail when the .Send does not work?

by

Your email security settings are what is most likely causing the issue. In outlook>>File tab>>Options>>Trust Center>>Trust Center settings>>Programmatic Access. – Sorceri 1 hour ago

In line with what @Sorceri said, you may, or may not be able to change those settings, according to IT department. For example, in my current job, I can only display emails automatically, but cannot send them through code. Cyber-Security team will not allow it. – Scott Holtzman 56 mins ago

So it seems like the verdict is that the SendKeys is the best option because security settings that are controlled by my IT department have locked me out of the programmatic access in trust settings.

Thank you to @Sorceri and @Scott Holtzman

More Related Contents:

  1. Sending mail using Outlook where the Send method fails
  2. How to send email to multiple recipients with addresses stored in Excel?
  3. How to Send Email When Computer is Locked?
  4. How to copy Outlook mail message into excel using VBA or Macros
  5. Copy Excel range as Picture to Outlook
  6. Paste Excel range in Outlook
  7. Update excel sheet based on outlook mail [closed]
  8. Email a single attachment from folder of files each to a different person
  9. How to add an attachment to an email using VBA in Excel
  10. Type Mismatch in Loop to scan Outlook Messages [duplicate]
  11. Finding a workbook in one of multiple Excel instances
  12. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  13. Change HTML email body font type and size in VBA
  14. Sequence of numbers based on start and end value of 2 cells [closed]
  15. Function to convert column number to letter?
  16. Better way to find last used row
  17. 2 Dimensional array from range [closed]
  18. Using Google Chrome in Selenium VBA (Installation Steps)
  19. Dir() function not working in Mac Excel 2011 VBA
  20. How to use workbook.saveas with automatic Overwrite
  21. How do you run a .exe with parameters using vba’s shell()?
  22. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  23. How do you get a Range to return its Name?
  24. Passing variable from Form to Module in VBA
  25. Excel VBA: Convert a date string to a Unix timestamp
  26. excel to pdf ignores print area and calls printer
  27. excel vba freeze pane without select
  28. VBA WinHTTP to download file from password proteced https website
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment