You need to give the user a choice of buttons, one for Ok, the other for Cancel (vbOKCancel). Then, check the button choice. If they choose Cancel, then end the script. If they choose OK, then make a call to the proper application to generate the email with the address and perhaps subject line already filled. That will depend on which application object you are using for email.

You can also prompt the user for the email information (Subject line, message, etc), using input boxes, and then package and send the email using an SMTP emailer.

HTH

mmcdonal