View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] EM.Bateman@gmail.com[_2_] is offline
external usenet poster
 
Posts: 1
Default Making email button work after email

I have a spreadsheet with a "submit" button that allows the user to
email wo worksheets to a routing list (defined in the worksheet - a
range named "routing"). How can I make the email button work in
subsequent emails? It works for the first user but when the second
user on the routing list clicks "submit" they get an error.