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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-20 : 07:49:49
|
| Julia writes "I am trying to send email to multiply receipents and having problems, I ma having problem with @TO = n[@MsgTo2;@MsgTo1;@MsgTo3;;@MsgTo4],Here is what I have:select @MsgTo1 = 'julia1@yahoo.com'select @MsgTo2 = 'julia2@yahoo.com'select @MsgTo3 = 'julia3@yahoo.com'select @MsgTo4 = 'julia3@yahoo.com'execute master.dbo.xp_smtp_sendmail @FROM = @MsgFrom, @FROM_NAME = @MsgFromName, @TO = n[@MsgTo2;@MsgTo1;@MsgTo3;;@MsgTo4], @BCC = @MsgBCC, ---------------------------------------- @subject = @MsgSubject, @message = @HTMLBody, @type = @MsgMIMEType, @server = @MsgServerThank you" |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-12-20 : 14:09:58
|
Julia,Try this instead:@TO = N@MsgTo2 + ';' + N@MsgTo1 + ';' + N@MsgTo3 + ';' + N@MsgTo4 Ken |
 |
|
|
|
|
|
xp_sendmail