We have a database for our ERP that has numerous stored procedures for sending emails out of the ERP.
One of the stored procedures generates a signature that grabs data from the ERP such as name, company name etc...
I want to remove this signature since we use an exchange signature but I am not sure how to trim this string.
Can someone help?
I am guessing it is somewhere in here:
SET @lsPropertyName = 'HTMLBody' SET @lsPropertyValue = REPLACE(@avc8000_EMailMessage, CHAR(10), '<BR>') DECLARE @TEXT AS VARCHAR (100) EXEC @llHResult = sp_OASetProperty @objCDOMessage, @lsPropertyName, @lsPropertyValue IF @ac1_SetSDOLETraceOn = 'Y' INSERT INTO @tblSDOLETrace values ('"EXEC @llHResult = sp_OASetProperty @objCDOMessage, ' + @lsPropertyName + ', ' + @lsPropertyValue + '"', @llHResult)