Hello there.
I'm having a problem setting the 'type' paramter of the MS SQLServer xp_sendmail procedure. I can generate appointments (IPM.Appointment) and these types of mails but I want to generate a custom form that I've designed myself.
Basically I want to get SQLServer to generate an automail that only allows the recipient to click "accept" or "reject" instead of "reply","forward" etc. We're using Exchange 5.5 and Outlook 98. In my own theoretically perfect world, I think I should be able to design an email form, publish it (ie, IPM.Note.Myform) and then call it from SQLServer using xp_sendmail.
I know that this may very well be a problem with my abilities (or lack of) using Exchange and Outlook but any help would certainly be appreciated anyway. Thanks in advance.
cheers,
shane mcdarby
I'm having a problem setting the 'type' paramter of the MS SQLServer xp_sendmail procedure. I can generate appointments (IPM.Appointment) and these types of mails but I want to generate a custom form that I've designed myself.
Basically I want to get SQLServer to generate an automail that only allows the recipient to click "accept" or "reject" instead of "reply","forward" etc. We're using Exchange 5.5 and Outlook 98. In my own theoretically perfect world, I think I should be able to design an email form, publish it (ie, IPM.Note.Myform) and then call it from SQLServer using xp_sendmail.
I know that this may very well be a problem with my abilities (or lack of) using Exchange and Outlook but any help would certainly be appreciated anyway. Thanks in advance.
cheers,
shane mcdarby