March 19, 2002 at 5:38 am
Any one know how I can use the ";" as a character within a stored procedure eg I am trying to use SQLMail to send an email to an x400 email address where the separator is a ";" eg [x400:c=gb;p=test;]
March 19, 2002 at 6:15 am
Is the SQL Mail client you are using MAPI? Also have you sent the message thru the client directly to see what happens? Lastly can you post how you are sending and what error message you are receiveing.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 19, 2002 at 7:12 am
The mail client is MAPI, when I send it through the client eg Outlook it works fine,
The stored procedure is
CREATE PROCEDURE emailme AS
exec master.dbo.xp_sendmail
@recipients='[x400:c=gb;p=nhs national int;a=nhs;dda\:rfc-822=aslam.atcha(a)bury-roch-ha.nwest.nhs.uk] ',
@type='X400',
@message="test",
@subject="test"
GO
And the error message is
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Unknown recipient: Parameter '@recipients', recipient '[x400:c=gb'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply