D
David Lightman Robles
Hi all,
We need to automatically create task items in our employees Outlook task
list. We manage to send emails using xp_sendmail, but it is not enough since
it sends a plain-text email. We have seen that when Outlook sends a task
assignment request, it attaches a winmail.dat file (content-type:
'application/ms-tnef') to the email and we are looking for a way to generate
that file from a command line tool or any other way appart from Outlook
itself. We would later send the email to the user using xp_sendmail (or any
other way from SQL Server when certain criteria are met: triggers, scheduled
batch jobs, etc), but that would be the easy part.
We have been doing some tests using automation to generate those taks and
send them using vb (from Access), but since latest service packs and patches
prompt user to accept an outsider program trying to access Outlook contacts
and also when sending an email in the name of the user, automation would not
be a solution. Everything should run from the server side without any user
intervention when gererating the task request. Later, when the users receive
the server-assigned task, they would just accept it.
Has someone faced this challenge before? Any ideas would be greatly
appreciated.
We need to automatically create task items in our employees Outlook task
list. We manage to send emails using xp_sendmail, but it is not enough since
it sends a plain-text email. We have seen that when Outlook sends a task
assignment request, it attaches a winmail.dat file (content-type:
'application/ms-tnef') to the email and we are looking for a way to generate
that file from a command line tool or any other way appart from Outlook
itself. We would later send the email to the user using xp_sendmail (or any
other way from SQL Server when certain criteria are met: triggers, scheduled
batch jobs, etc), but that would be the easy part.
We have been doing some tests using automation to generate those taks and
send them using vb (from Access), but since latest service packs and patches
prompt user to accept an outsider program trying to access Outlook contacts
and also when sending an email in the name of the user, automation would not
be a solution. Everything should run from the server side without any user
intervention when gererating the task request. Later, when the users receive
the server-assigned task, they would just accept it.
Has someone faced this challenge before? Any ideas would be greatly
appreciated.