We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Use SQL Server to send mail via Lotus Notes

zimmy
zimmy asked
on
Medium Priority
547 Views
Last Modified: 2010-03-19
I understand that Lotus Notes has a MAPI interface. How do I
get SQL Server to make the connection to Notes? I understand
the xp_sendmail stuff, it's the connection between SQL Server and Notes that I'm not sure of.
SQL Server 6.5, Notes version 4.5.2, on NT 4.0 sp3.
Comment
Watch Question

Commented:
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

Author

Commented:
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'

Author

Commented:
Adjusted points to 100

Author

Commented:
Adjusted points to 200
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
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.


Author

Commented:
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.

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.