Just 2 things here, can you execute the stored procedure in Query analyser using 'exec sp_name'
Also it might be a good idea to check the permissions on the stored procedure and in certain cases stored procedures that may be called from within.
Hows your VB :)
I had a similar situation and here is how i dealt with it.
I hope you have access to your server on your company intranet, if no this could be a problem.
First you can create a VB exe which points to your access database. The .exe will read the records and send the mail from the...
You can cheat, if the local machine has excel installed you can make the HTML page appear in Excel instead of HTML. All you need to do is change
Response.ContentType = "application/vnd.ms-excel"
at the beginning of the file,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.