[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

sending email with attachment with VBA in access 2000

Posted on 2011-10-03
4
Medium Priority
?
306 Views
Last Modified: 2012-05-12
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!
0
Comment
Question by:ifoto
  • 3
4 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1500 total points
ID: 36905376
CDO is fairly simple to use, and is very similar to CDONTS. Here's a good starting point:

http://www.rondebruin.nl/cdo.htm

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

Here's another:

http://support.microsoft.com/kb/161833

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

Author Comment

by:ifoto
ID: 36905625
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.
0
 

Author Comment

by:ifoto
ID: 37046936
not sure if this fixed the problem - but I unregistered CDONTS and that seemed to fix the problem
0
 

Author Closing Comment

by:ifoto
ID: 37046958
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
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

873 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