Sending e-mail, copy the direct recipient cell

Apologize that i stuckup with my work here.....

In your code pls inlude

HTML Code: 

replace you To code with below

HTML Code: 

While executing the code, whatever the mail id given in W6, will be picked by outlook as To address

Hope this helps...