Use SQL Server to send mail via Lotus Notes

no SP xp_sendmail stands for that to send mail through MAPI you must configure your NT to be a mail client to Lotus Notes after that you can sending mail

Odessa, sorry if my original question wasn't clear. You have restated the problem I'm trying to solve - '. . . configure your NT to be a mail client to Lotus Notes'

My original wording was 'the connection between SQL Server and
Notes'

Adjusted points to 100

Adjusted points to 200

Threshold,

I tried your process and got hung up trying to create a profile that would work. It asked me for five things:

-name: I entered the name that I logged on as.

-email address: Seems to be irrelevant. Besides, the server doesn't have an internet email address.

-internet mail server: I tried every combination I could think of  that pointed to my Notes server (name, ip address). Nothing worked.

-account name: I put in my Notes id.

-password: Easy. My Notes id is set up without a password.

After I created the profile I clicked on the Inbox to start it up. It tries to log on, is unsuccessful, and puts up a dialog box with Internet Mail Server, Account Name, and Password inputs. Nothing I seem to do works at this point

I don't understand the logic of creating an internet mail profile, but if you think it will work, and have any more ideas, I'll keep on trying.

Thanks.

Z.

I didn't use Notes, but I am sure that Internet Mail should be supported by it.
Can you use the Netscape to receive/send mail via Notes?
If the answer is yes, Notes will support SMTP and POP3 protocol, and the Mailbox Profile will work with Notes.
The Profile need five fields to be filled:

Name : your full name to be displayed in mail (ie: Scott Chen)
Email Address : Your Email Address. It will be displayed in mail for replay. And It should be the mail address on Notes server.
                           (ie: scott@mynotes.mysite.com.tw)
Mail Server : the DNS address or IP address of your Notes, (ie: mynotes.mysite.com.tw)
Account : a login account of your Notes
password : the password of the login account above.

The setup is just like as Netscape Mail Client.
Make sure that you can receive mail with the Profile via Internet mail, then setup the SQL Mail to use the profile.

hope it will work.

I don't mean to be rude, but if you don't KNOW the answer to a question, you probably shouldn't try answering it.

Lotus Notes is a proprietary workgroup/email software package. It can't use Netscape to send email, never could. The version I have doesn't support SMTP or POP3.

My question SPECIFICALLY mentioned MAPI.

Thanks for trying, though.

So, I gived your 3 methods. And the 2nd/3rd one are the solutions you need.
Try the sp_OAxxx stored procedure, or write the xp_xxx for SQL Server by VC++.
It's the only way to let  MS SQL to access MAPI(Notes) directly.
Maybe, you can create SQL Client on your Notes, to let Notes to access SQL.
If I were you and I know about MAPI of Notes, I will create a SMTP/POP3 server as gateway between Nots and Internet Mail.
I know it's not easy, but it will be most useful solution. Try to search the gateway products on net or Lotus, maybe, there was one as you need.

Threshold,

Thanks for trying. Sorry I took so long to respond; I was on vacation last week.

I've run out of time on this one, so I'm giving up on Notes and trying another approach (bcp/ftp/PROFS) to get the mail out.

Thanks again.