View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 9
Default Random Selection

Hi,
I have a subscriber email address list of over 20,000 Email addresses.
I would like to be able to click a button on a sheet and a dialogue box
appear displaying an
Email address which has been randomly selected from the list. Is this
possible? If so I would really appreciate some help on accomplishing this
task.
Also, on the dialogue box, would it be possible to have a button which when
clicked, copies the address selected to the To... field of a new email in MS
Outlook 2003.
Regards

John