I have a vba macro that works correctly in Win 7 & Vista, but it fails to send the email in Windows 10.
If I step through the macro, it fails at Line 81, Col 14 where it says
.Send
ITS THIS BIT:
"This is a auto generated email, please do not reply." .AddAttachment "c:\Temp1\" & Sheets("Sheet1").Range("AX1").Text & " " & " A Closing Sheet" & ".xls" .Send
Can anyone tell why this is now failing and if there's a usable workaround that may NOT involve using Outlook.
Attached is the .xls workbook.
Its saved like this as the same format across different versions of Excel to accommodate everyone.
Thanks