MACRO HELP

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

Hi all, I have a macro set up to email certain people once clicked with
certain information.

Is they any way i could type around 6 email address in cells a1, a2, a3, a4,
a5 and a6 and if the user decides to email cells a1 and a3 for example it
will only email whichever email address is in there. Or if you can think of
a better way?

Much appreciated.

Neil.
 
I think probably an input box would work, so that the user could select the
ranges:

addr = Application.Inputbox("Select Recipients", "SEND TO", Type:=8)
ActiveWorkbook.SendMail recipients:=addr
 
Back
Top