SQL 7 Mail w/ remote Lotus Notes Server

[Glenn Tucker]

I once had SQL Server 7 running with an on-site Exchange
Server. That worked well. A new company has taken over
our plant. Their headquarters is in South Carolina along
with a lotus notes server for email.

Does anyone have any suggestions how I can get my SQL mail
working with a remote lotus notes server? Do I need some
internet asp email to make it work?

Thanks for your help!

[Dinesh TK]

Glenn,

My colleague had the same issue.Lotus notes are not supported with SQL mail
unless its configured as a POP3 server.Thats mentioned in
Q263556 INF: How to Configure SQL Mail
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q263556 . Iam
reproducing a reply we found in google archives posted by Kevin which uses
CDONTS.See if that helps..!

----------------
I use Lotus Notes at my work too and this is a script I
use to send out emails. Just insert the this into a
ActiveX Script Task. This is script is in VB Script by the
way. Make whatever changes you want.

Kevin

'**********************************************************
************
' Visual Basic ActiveX Script
'**********************************************************
**************

Function Main()
set objNewMail =CreateObject("CDONTS.NewMail")
objNewMail.From="who...@whoever.com"
objNewMail.To="who...@whoever.com,
who...@whoever.com"
objNewMail.Subject="whatever"
objNewMail.Body="whatever"
objNewMail.BodyFormat = 0
objNewMail.MailFormat = 1
objNewMail.Importance = 1
objNewMail.send
Main = DTSTaskExecResult_Success
End Function

-------------

More info.abt CDONTS is in:

Q312839 : How to send email from sqlserver without using sqlmail.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839

Another alternative is
XPSMTP.DLL - SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm

Dinesh.
--
---
SQL Server FAQ at
www.tkdinesh.com

"Glenn Tucker" <glenn....@sonoco.com> wrote in message
news:baf801c20c9d$92131c80$3aef2ecf@TKMSFTNGXA09...

[Glenn Tucker]

Hi, Dinesh TK

Thanks so much for the help. That was driving me crazy. Now, my
purpose for the mail is to do alerts.

Did your friend get the sql mail to work for alerts with the POP3?

Do you use this DTS Script for alerts/triggers? If so, how did you set
it up?

I really appreciate the help.

Glenn Tucker

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!