asked on

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

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?

gbzhhu

You could use CDO for windows

gbzhhu

Look at here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdo/html/_olemsg_adding_attachments_to_a_message.asp

yronnen

This one's free:
http://www.brothersoft.com/Software_Developer_Visual_Basic_OstroSoft_SMTP_Control_6826.html

vinnyd79

There is also the free vbsendmail component:

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

csferguson

ASKER

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?

gbzhhu

CDO for windows should work with Access as long as you are running Windows 2000 ar above

csferguson

ASKER

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.

ASKER CERTIFIED SOLUTION

modulo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial