I have a macro that splits an Excel workbook into separate files and generates an email to the respective recipients for each file. I have a sub for each individual file created. I used to not have issues, but just recently received an error after the first sub successfully ran and sent an email.
The error I am receiving is: Runtime error 1004: General mail failure.
Here is the the code that I am receiving the error on:
ActiveWorkbook.SendMail Recipients:=Array("user@domain.com"), Subject:="Monthly T&E Expenses"
Any thoughts? Again, the first sub is working fine, and I am not receiving the error until the 2nd sub is called (I have 18 total subs).
Thanks for any help - I am at a loss.
Rob
The error I am receiving is: Runtime error 1004: General mail failure.
Here is the the code that I am receiving the error on:
ActiveWorkbook.SendMail Recipients:=Array("user@domain.com"), Subject:="Monthly T&E Expenses"
Any thoughts? Again, the first sub is working fine, and I am not receiving the error until the 2nd sub is called (I have 18 total subs).
Thanks for any help - I am at a loss.
Rob
