Hello, I have a simple automated "send as attachment" macro in an excel workbook:
> Private Sub SubmitButton_Click() > ActiveWorkbook.SendMail Recipients:="<email>", Subject:="<subject>" > End Sub This works fine when Outlook is the default mail client, but not when TB is selected, returning: > Run-time error '1004': > Method 'SendMail' of object '_Workbook' failed Can anyone tell me how to make this work please? Regards, -- Nick Using The Bat! v1.61 on Windows XP 5.1 Build 2600 Service Pack 1 ________________________________________________ Current version is 1.62 | "Using TBUDL" information: http://www.silverstones.com/thebat/TBUDLInfo.html
