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.

Using SendMail:

ActiveWorkbook.SendMail recipients=Range("a1").Value, Range("a4").Value


"Neil Holden" wrote in message
...
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


"Neil Holden" wrote in message
...
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.