Good Morning Guys

In a macro that creates automatic e-mails I'm trying to take someone's name and then search for that persons details on another sheet and if it finds them, then it will return their e-mail address.

Here's where it gets slightly complicated. The persons name appears on sheet 'Transmittal Sheet' in Cell 'C12' and has their first name and last name in the same cell. When searching for them in sheet 'Contacts' Their first name is in column 'A' and their last name in column 'B' then their e-mail address is in column 'C'

Can anyone help me write some code that will split the name up and search for it in the contacts sheets?

Sorry this one is a pain in the bum, but I can't change the way the contacts sheet is set out.

Many Thanks in advance! Rep for any help as always!

R