Excel 2003
 

Hi all, hopefully you can help me.

In cell B21 the user will always input an email address, i have created a
button and now need the button to automatically email the email address in
cell B21.

I then need it to default and save to a specific location with the file name
automatically generated from b12.

Please help. :)