Copy email address then send email template to it

You might take a look at this macro, and adapt it for your needs.