Post reply

SQL Mail

  • June 6, 2006 at 3:31 pm

    #113312

    We are using Lotus Notes as our email system. Is it possible to make sql server talk to lotus notes? if not is here any work around it to recieve sql server mail?

     

    thanks

  • June 8, 2006 at 5:59 am

    #642479

    I cannot say definitively that this will work, as I have not specifically done this .  But I know you can setup Outlook to use Notes (I have done that, but I don't remember off-hand if the driver for Outlook is from Microsoft or from IBM; googling should find that answer).  Once you have an Outlook profile setup for using Notes, then SQL Mail should work.  SQL Mail does not know the difference what Outlook is using (exchange, pop, notes, hotmail, etc); it is only using the MAPI profile that Outlook provides.

    Of course, another alternative is to use any of the number of SMTP stored proc listed on this site and others, and use the SMTP service of the Notes server.

    Hope this helps



    Mark

  • June 9, 2006 at 3:52 pm

    #642931

    We use notes, and I had to use a VB script to send mail when an event happens. Part of my problem though, was that our IT folks had their hair turn white and stand on end when I mentioned putting Outlook on the database server. 😉

    There are lots of examples to choose from out there for using VB script to send mail from SQL Server, so you shouldn't be far from a solution. The only real downside is that you won't get the server generated alerts that would normally be sent by SQL Server itself. There may be a way to do that, I've just never found it...

    Steve G.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply