June 17, 2003 at 7:43 am
Folks,
Good day! Currently, I have my CRM configured to generate emails to our customers when a service incident has been closed in the CRM. The e-mail is generated via the xp_sendmail sproc called from another sproc (stored procedure). The request came down to make the e-mail look more like an e-mail that is html formatted or atleast has better layout than using lines of text with embedded char(13) + char(10).
I've spent some time online looking for appropriate resources, but don't see anything. Can someone direct me towards either the programmatic resource or a third-party that might be invoked? I might be in a position where I need to generate a vb app running on the Exchange server polling a db table...
Thanks!
June 17, 2003 at 9:38 am
quote:
The request came down to make the e-mail look more like an e-mail that is html formatted or atleast has better layout than using lines of text with embedded char(13) + char(10).
in fact, html formatting is nothing different. just the html tags. I'm not sure if the exchange server handling the sql mail account must be changed in some way. And of course the clients' mail app must be able to interpret.
quote:
I've spent some time online looking for appropriate resources, but don't see anything. Can someone direct me towards either the programmatic resource or a third-party that might be invoked? I might be in a position where I need to generate a vb app running on the Exchange server polling a db table...
If you're looking for code snippets, try this one:
Hope that helps!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply