This actually sounds like a good idea! all I have to do now is work on creating the loop. Anybody want to provide a code sample?
quote:
Table data type can't be used as a parameter in stored procedures!you will have to create a loop to cyle through the table to either send an message per rep or better yet concatenate all reps email addresses separating them by semicolon
and send a unique email with the recpientlist built as explained above
HTH