send xl file thru email
Posted by Stacy on April 06, 2001 11:00 AM
Hello...I am trying to email an excel workbook through vba....I am using the line:
I use Lotus Notes....and it worked fine the first few times....now I am getting an error that says, "Run time error 1004: Method of 'SendMail' of object '_Workbook' failed." Does anyone have any suggestions on this? Is there any other code I could use that would make it work??
Thanks in advance!!