I'm trying to send an email with an attachment using VBA and Access 2000. this wokred with CDONTS but stopped working after a recent set of MS updates. we are trying to use CDO (CDOSYS.DLL) but getting an error. works when the program is logged on (they have admin rights) but user cannot send and gets an error - I'll get the error code.
the setup is:
Server 2003 X64 running terminal server (remote desktop)
Outlook is not installed on this system
trying to move way from CDONTS and use CDO (or whatever is supported at this time - is there a better way?)
Worth 500 points - we have wasted a few days on this and need to move foward