MACRO HELP
 

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.

MACRO HELP
 

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.

MACRO HELP
 

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.