I am trying to write a stored procedure to autmatically send an e-mail. The documentation has an example to use when the e-mail you need to send is more than 255 characters which is my case. I can get it to work but, I also have a need to insert the value from a variable into the text and this is where I am having the problems. I am getting an implicit conversion error even though I am expclitly converting the varchar variable to text.

Any help would be appreciated.

text below:

Create table ##texttab (c1 text)
Declare @IncID varchar(10)
Select @IncID = '1234'
Insert ##texttab (c1)
values(
'Dear Client,

Your customer care incident '+convert(text,(@incID)) + ' has been resolved. We are following up with this email to ensure that you are completely satisfied. Please respond to this email if the issue is reoccurring for you and we will re-open your case.

Thank you,
Technical Support

=================================================
For technical support, contact Service and Support Monday through Friday, excluding recognized U.S. National Holidays, between the hours of 8:30 A.M. - 8:00 P.M., Eastern Time. Or send us email at . You can also access our online support option by going to the For Customers section on our website.&#39

Declare @cmd varchar (56)
Select @cmd = 'select c1 from ##texttab'

EXEC xp_sendmail @recipients='egolds@yahoo.com',
@query = @cmd,
@no_header='TRUE',
@subject='Closed Incident Update',
@width = 80
Drop Table ##texttab