By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,933 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,933 IT Pros & Developers. It's quick & easy.

Sending emails from Access - problems with Microsoft Exchange and vbSendMail.dll

P: n/a
Hello World:

I'm trying to build an application (using Access 2003) that will allow users
who have to perform tasks in a particular order, to notify the next person
in line when their task is complete. I'm trying to have the application
send an email to the next person upon task completion. I looked over the
info concerning emailing and Access at Tony Toews' site (thanks for that,
Tony).

I finally came up with some Visual Basic code from FreeVBCode.com, which is
a VB6 project that produces vbSendMail.dll. This dll uses Winsock to do its
work. The dll is so simple, and works so well from Access when I do it from
home.

When I try it against our Microsoft Exchange server at work, however, it
just fails. The big problem seems to be in capturing the SMTP Host
correctly. I have the guaranteed correct name of our Exchange SMTP Host
from our Exchange Admin. The MXQuery utility that comes with vbSendMail
verifies the SMTP Host name. We are using the standard Port 25. But it
doesn't find the Exchange SMTP Host.

Does anyone out there have any experience with emailing from Access inside
of a Microsoft Exchange email system? Does anyone have any idea why the dll
can't find the SMTP Host? Any help is greatly appreciated.

Alan
Apr 20 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.