sending email with attachment with VBA in access 2000

Posted on 2011-10-03
Last Modified: 2012-05-12
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
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

Question by:ifoto
    LVL 84

    Accepted Solution

    CDO is fairly simple to use, and is very similar to CDONTS. Here's a good starting point:

    This is marked for Excel, but will work with any flavor of VBA.

    Here's another:

    If you cannot get those to work, post your own code (using CDO) and indicate where you're having troubles.

    Author Comment

    I posed the code and it seems to be also related to if the user has administrators  (group)
    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.

    Author Comment

    not sure if this fixed the problem - but I unregistered CDONTS and that seemed to fix the problem

    Author Closing Comment

    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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now