Find email addresses from a list websites

I have two spreadsheets with 630 contacts sourced from LinkedIn.

We have the following key information (amongst other columns)

- First Name
- Last Name
- Job Title
- Company Name
- Location
- LinkedIn Personal Profile URL
- Linkedin Company Page URL

I need someone to find an email address for each person by looking up their company website, or company page on LinkedIn, whichever is easier.

The email address ideally should be that person individually, but I understand that won't be possible for all of them, so we are happy with generic emails in that case eg sales@companyname or marketing@companyname etc.

Thanks.