Hi all,
I hope someone can help me with the following problem in sharepoint 2010. I created a new custom list for our admin staff to log incoming telephone calls to school. Some of the info thats recorded is: person calling, looking to speak to, pupils name etc. Once a call is recorded, a email is sent to the relevant staff. This is done either by taking a screen shot of the call details or the list info is copy/pasted into an email.

I am trying to find a automated and less time consuming method. I know workflows can be used but i've never used it before. Am newbie in sharepoint stuff. Is it possible to do a lookup for the "looking to speak to" field for the staff name which is linked to email account on AD or have a separate list which contains the staff name and email address.

Any help on this would be very much appreciated.

Haz