simora
04-14-2017, 04:44 AM
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
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