Select Winning Email

J

John

Hi
On my form "frmEmailSelect" I have a subform "frmSubFrmEmails"which lists
Email addresses in datasheet view.
On the main form I have a command button which I would like to click, and a
random email to be selected as a winning email address. I would like this
email address to be displayed in a text box and a command button which would
copy the winning email address to a new recipient in Outlook.
Can this be done?

Regards

John
 
Top