I'm getting the error "No recepient is specified".
I have set up a dataflow from a select statement into a record set, then have that dataflow point to a ForEach group with a mail task in it. I have set up variables for the username and subjectline. So in the mail task I have no value in the To: line because I specify an "http://www.sqlis.com/59.aspx">http://www.sqlis.com/59.aspx exactly.
I couldn't figure out how to included screen shots.
Any ideas
send mail using variables from select statement
Bill26
Sounds like you haven't set the To parameter properly.
If you follow the instructions on the link, you should see the variable name in the To line not a blank field.
One thing you can try is disable the send mail task, use a breakpoint on the foreach loop and set it to break after each iteration. Watch the value of the variable you are using for the To address. That will help diagnose the issue further.
Alan Cobb
Chardiot
Actually the To line is blank in the example. The value is set in the