July 8, 2010 at 8:41 am
Hi,
Is there any way to send emails from SQL Server using Outlook templates (oft)?
Thanks in advance.
July 9, 2010 at 2:53 am
Any ideas please?
July 9, 2010 at 9:01 am
Your best bet is making an application or SSIS package to do this. Then use xp_cmdshell or SQL agent to call on that application or package.
July 9, 2010 at 11:00 am
I don't think that will not work. Outlook.exe accepts no exposed command line arguments, so you could not automate it like that, i think.
what's wrong with opening a new email based on the template, then changing it to html and view the source?
then you can use that as the source basic format of the email and substitute in your content.
Lowell
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply