Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skybvi
Posting Yak Master
193 Posts |
 Posted - 2011-04-08 : 14:08:07
|
| HI, We had sql server 2000 last year and now some time back changed to sql 2005..We have a procedure whcih runs and sends email :- EXEC msdb.dbo.sp_send_dbmail @recipients = ' Person's name' ....So we used to receive email earlier when sql 2000 was in use... as it connected the person's name to the email address from microsoft outlookNow in sql 2005, we arent been able to receive the email....If i write whole address in--@ recipients = 'xyz@abcd.com'Then iam able to receive the mail but not when I just mention then name ...IS there a compatiblity issue with sql 2005 and outlook??I dont know wats wrong...Regards,SushantDBAWest Indies |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-04-08 : 14:58:44
|
| So, is it possible to link database mail to use the outlook?Thanks.Regards,SushantDBAWest Indies |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-04-08 : 15:41:26
|
| Yes, maybe u r correct..But I am confused about 1 thing..If i send like -->@recipients = 'xyz@abcd.com'I receive the mail in outlook but in the TO section it says'X Y Z',why doesn't it say TO:- 'xyz@abcd.com' That means it comes through outlook right?Why isnt it opposite then..??just wondering..Regards,SushantDBAWest Indies |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
database mail nt sending mails