?
Solved

How can I programmatically send attachements via an Access 97 application without using Outlook.

Posted on 2005-03-30
9
Medium Priority
?
183 Views
Last Modified: 2010-05-02
I am trying to programmatically send Access reports as attachments (preferably mutliple attachments per email).  The only mail client installed on the workstations is Outlook Express.  Any suggestions?  Are there any free or cheap mail clients that will work with the sendobject command or is there another route I should go?
0
Comment
Question by:csferguson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
9 Comments
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13662285
You could use CDO for windows
0
 
LVL 5

Expert Comment

by:yronnen
ID: 13662591
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 28

Expert Comment

by:vinnyd79
ID: 13663285
There is also the free vbsendmail component:

http://www.freevbcode.com/ShowCode.Asp?ID=109
0
 

Author Comment

by:csferguson
ID: 13673063
The access app I am trying to add this functionality to is Access 97.  The OstroSoft SMTP Control appears to have a minimum system requirement of Access 2000.

Should CDO for windows work with Access 97?
0
 
LVL 12

Expert Comment

by:gbzhhu
ID: 13673147
CDO for windows should work with Access as long as you are running Windows 2000 ar above
0
 

Author Comment

by:csferguson
ID: 13674414
Do you need to have an email client that supports automation to use CDO?  I've got it working with CDO when I run it from a computer with Outlook installed, but I can't get it to work from my computer that only has Outlook express installed on it.  In the end I will need this to work on PCs without Outlook installed.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14395912
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

764 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