I have an application written in Access97 in which I want to select records from a table and e-mail the result. I've set up a macro which will run a query over the table and then I've used SendObject to export to an .XLS spreadsheet which I want to mail. I've tried to run this macro on two machines and both come up with the error "Microsoft Access can not open the mail session. Check mail application to make sure it's working properly". We're using Microsoft Outlook as the mail application, and yes, we can send and receive messages outside of Access.
Any tips or suggestions of where to start to pinpoint the error? [sig][/sig]
Any tips or suggestions of where to start to pinpoint the error? [sig][/sig]