Sendmail task error...

• quillis131

  Hall of Fame

  Points: 3706

  More actions

  March 14, 2011 at 1:25 pm

  #236742

  i need to send a mail with attachements...

  i used variables to addresss my fields (to, from, cc and also attachements )

  but i get this error, when i excute it "the specfied string is not in the form required for an email address[/size]"

  my email address has abc@xxxx.com

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 15, 2011 at 1:18 am

  #1298698

  Are you 100% sure you have correct emailaddresses for all the fields?

  Maybe one of variables is empty, leading to the use of NULL in a field.

  You can set a breakpoint in your package and inspect the values of the variables in the Locals window.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP