ifoto
asked on
sending email with attachment with VBA in access 2000
Hi,
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)
Access 2000
VBA
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
thanks!
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)
Access 2000
VBA
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
thanks!
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
not sure if this fixed the problem - but I unregistered CDONTS and that seemed to fix the problem
ASKER
this was all information I had already found so it was the right stuff.
My issue seemed to be unique. and still not sure what the cause was but removing CDONTS from the VB program seemed to solve the problem
My issue seemed to be unique. and still not sure what the cause was but removing CDONTS from the VB program seemed to solve the problem
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
again it works for our programmer (she is logged on as a administrators equivalent) and we are on a server 2003 running Remote Desktop Services
of course I don't want all my users to be admins.