Try the following code to execute a stored procedure from VBA

Dim cnn As ADODB.Connection

Dim...

Here are couple of links which may be helpful.

http://msdn.microsoft.com/en-us/library/ms252091(VS.80).aspx

http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx

Please use the variables declared in the attached example to set the @body parameter of the procedure dbo.xp_smtp_sendmail.

You can use the html tags to format your email body as you...

By Default SQL Mail is not enabled in SQL Server2005 and xp_SendMail uses SQL Mail. You will have to enable it before using it.

It is recommended to use Database Mail...