I have the following code in a stored proc:
use master
EXEC xp_startmail
EXEC xp_sendmail
@recipients = 'user@domain.edu',
@subject = 'Accrual Suspension Change',
@message = 'Test'
EXEC xp_stopmail
It gives me the happy messages that it worked, but I never receive the email. Obviously, the address here is not valid but the one I am actually using is.
I have checked that my profile for SQLMail works but sending a test and I receive that just fine.
Any ideas would be most appreciated!
Thanks,
Eva
use master
EXEC xp_startmail
EXEC xp_sendmail
@recipients = 'user@domain.edu',
@subject = 'Accrual Suspension Change',
@message = 'Test'
EXEC xp_stopmail
It gives me the happy messages that it worked, but I never receive the email. Obviously, the address here is not valid but the one I am actually using is.
I have checked that my profile for SQLMail works but sending a test and I receive that just fine.
Any ideas would be most appreciated!
Thanks,
Eva