Data Validation for 400 Contacts

General information for the business: Event Company
Industry: Business
Description of excel work: Hello

I am running an event and have a list of contacts I want to invite. I have all of their information except their email addresses.

I need you to search for the email format of each company and then enter this in to an Excel spreadsheet that I will send you

You may not find the exact name of the person I am looking to invite but this doesn't matter, once you have the format, you can just change the name to match my contacts.

I usually do this myself but am out of the office and need some extra help.

I have attached an example of the contact list.

Do send me any questions you have. I need to get this done as soon as possible so please only reply if you are available to work immediately.

I look forward to hearing from you.

Andy
Extra notes: