Place a message in the outbox of Outlook
in [Server Configuration]
|
Prev: .net runtime optimization service event viewer Error
Next: Select previous 52 weeks for every week in calender table
From: ab on 23 Feb 2010 02:53 Is there anyone out there who can tell me how to place a simple message from within T-SQL into my Outbox of Outlook (not Outlook Express) on the same machine? I have SQL Server 7, I don't have an Exchange server and I haven't setup Mail in SQL Server. Any help will be appreciated.
From: Sorna on 23 Feb 2010 05:36 I think you can write a code or small exe with outlook API's and call it using xp_cmdshell in the T-Sql code But enabling xp_cmdshell is not advisable as it can cause security risks to the server or the machine "ab" wrote: > Is there anyone out there who can tell me how to place a simple > message from within T-SQL into my Outbox of Outlook (not Outlook > Express) on the same machine? I have SQL Server 7, I don't have an > Exchange server and I haven't setup Mail in SQL Server. > > Any help will be appreciated. > . >
From: TheSQLGuru on 23 Feb 2010 09:23
There is a bunch of stuff in a flavor of Visual Studio exposing all kinds of APIs for Microsoft Office Suite of products. Other poster recommended xp_cmdshell, but I would recommend the CLR instead. -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "ab" <absmienk(a)hotmail.com> wrote in message news:7152d51c-95a1-41bc-95c5-26adc3bce417(a)v25g2000yqk.googlegroups.com... > Is there anyone out there who can tell me how to place a simple > message from within T-SQL into my Outbox of Outlook (not Outlook > Express) on the same machine? I have SQL Server 7, I don't have an > Exchange server and I haven't setup Mail in SQL Server. > > Any help will be appreciated. |