Does anyone know about this?
I am developing a database MS Access frontend with SQL Backend, using stored procedures on SQL Server 2000.
What I want to do is email an attachment that includes data generated from a stored procedure to the customer that the database record that has been generated using MS Outlook.
I have tried xp_sendmail and setting the attachment variable to True, however this only sends a Txt file and the formatting within this is not good. I want the same functionality but using an excel spreadsheet or html file.
I have also looked at the sp_createwebtask function but in practice it doesn't do want we want under the permissions because the logged on user needs to be a member of the sysadmin group. Have tried using the sp_runwebtask after defining the requirements in sp_createwebtask but that would then over the file and then we can't keep a record of the emails and files that have been sent.
Any other ideas?