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 |
|
loxaluck
Starting Member
2 Posts |
 Posted - 2007-11-27 : 08:44:39
|
| hello:can anyone tell me how to embed a single quote that is part of a name in the @recipients= paramter of the xp_sendmail.for instance:xp_sendmail @recipients=joe.smith@xx.com;nancy.o'donnell@xx.com;tim.bim@xx.com',@attachments='xx.txt',@subject='subject'i tried ' and `.thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-27 : 10:09:33
|
| xp_sendmail @recipients=joe.smith@xx.com;nancy.o'''donnell@xx.com;tim.bim@xx.com',@attachments='xx.txt',@subject='subject'This should work. |
 |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-27 : 10:11:21
|
| try adding a second quote...xp_sendmail @recipients='joe.smith@xx.com;nancy.o''donnell@xx.com;tim.bim@xx.com',@attachments='xx.txt',@subject='subject' |
|
|
|
loxaluck
Starting Member
2 Posts |
Posted - 2007-11-28 : 10:37:45
|
| much thanks, looks like the 2 quotes worked though I'm not sure why. the 3 quotes made sense because you are throwing a quote within quotes. but 2 ? |
|
|
|
|
|
|
embedding quotes on recipent name in xp_sendmail