EXCEL - Selct a list of names with radio button, then email them

[adamf]

I am trying to create a fault reporting form in excel, that depending on the nature of the fault needs to be emailed to any number of people.

I have a list of all the people who may need to be mailed the report, but wonder if anyone can help me to:

1) Add a tick-box or radio button to each name in the list

2) Write a macro that on the push of a button, emails the report to eveyone whose name has been ticked

EG. This should send the report to Adam, Bill & John, but NOT Fred or Mike

Adam [x]
Bill [x]
Fred [ ]
John [x]
Mike [ ]

Thanks in advance.

Adam

Adam F
Solaris System Administrator

 

[GlennUK]

Is this fault reporting form to be generated as an Excel worksheet with embedded objects?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[adamf]

Glenn - I'm not really sure what you mean by embedded objects, sorry.

The form will be completed using a mix of drop-down field and freeform text.

Ideally the report will then email itself, ideally as a PDF file to the selected users.

Adam F
Solaris System Administrator

 

[kjv1611]

adamf,

This one should be handled over at:
forum707

That's where you'll get the best help on this issue, and it's the best place, so that if someone needs the same or similar help in the future, it'll be easier to find.

--

"If to err is human, then I must be some kind of human!" -Me