DTS SendMail Task for BCC

[sanjdhiman]

Hi

I am wondering is there a work around for the SendMail Task BCC property in VB Script (ActiveX task). Does it exist?

Is there a work around?
Thanks for your help

Sanj

 

[mutley1]

Hi Sanj,

What exactly do you mean "a workaround" - what are you trying to achieve? Need a bit more info because the question is a bit open!

Cheers,

M.

 

[sanjdhiman]

Trying to send an email using the sendMailTask. Within this task there are properties regarding whom you want to send an email to. i.e. To and CC: . I however, want to send it BCC. I looked at the object properties and there is noway of doing a BCC. Is there a work around to sending an email BCC format?

Thanks

Sanj

 

[mutley1]

Hi Sanj,

You can use xp_sendmail as a SQL task (check it out in BOL) as there's a parameter that allows BCC called blind_copy_recipients.

HTH,

M.