View Single Post
  #2 (permalink)  
Old January 6th, 2016, 12:35 AM
Tom Urtis Tom Urtis is offline
Wrox Author
Points: 191, Level: 3
Points: 191, Level: 3 Points: 191, Level: 3 Points: 191, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2015
Location: San Francisco, California, USA
Posts: 35
Thanks: 0
Thanked 6 Times in 6 Posts
Default

Hi, and thanks for buying the book.

That error can be due to a couple of reasons. For example, if the strTo variable contains an illogical recipient name (such as, in a cell, a name has a space or disallowed character), VBA would raise an error. It might also be due to a server issue or a default IT setting that does not allow, or expect that, Outlook will be required to send the email. Hard to say without knowing the background of the environment you're working with.
Reply With Quote