I have an application i created in MSAccess that is supposed to create an .xls file, open outlook and attach it to an email and update some of the email fields. This was working fine for +2 yrs until recently I get the message "Microsoft Access has stopped working" and it closes.
the user has the following installed on their workstation:
MS Access Runtime 2013
MS Office Home and Business 2016
MS Access database engine 2010 (which is required for another program)
MS .NET Framework 4.7.2 (which is also required for another program)
Operating Sys is Windows 7 pro.
the MSAccess file they are using is an .accdb file
The macro that is causing the crash is:
EmailDatabaseObject
object type: Query
object Name: qUploadShipmentDetails
Output Format: Excel 97 (.xls)
to: (xxx@yyy.com)
Subject: = "Ref" & [forms]![fshptdetails]![field] & " -pickup request"
edit message= YES
The issue seems to be opening outlook and populating the new email. If i have ACCESS create the .xls file only everything works fine. As soon as i try to automate the application to open a new email and populate it with the .xls attachment and update the fields MSACCESS Crashes. It doesn't matter if Outlook is already open or not.
Can anyone suggest how to get this to work again. MS is 'forcing' us to accept their updates and each time I do I seem to run into a new problem.
thanks in advance