Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Intermediate Procedure

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2008-03-17 : 12:05:10
I have an xp_smtp_sendmail process which is looping to send emails to multiple recipients with individual details from tables.

The output is in HTML. I need to convert this to PDF and I have a process running with an input & output directory, working fine.

But how can I interrupt the currently fine xp_smtp_sendmail process to grab the HTML output, change to PDF and then continue sending...? (don't fix if it ain't broke)

I've thought about using sp_makewebtask but this is a lot of extra work to get the HTML template anything like the perfect one I'm using now...
   

- Advertisement -