**
Changing the associates email address from personal to their work address. Can be found on the firms website. Around 100 to 150 that need to be changed.
TO BE COMPLETED TODAY:**
1. Where there is a blank cell in **"column H Email"**, that cell should be populated with the associates firm (work) email address. The majority of the links / web adresses are functional, where they are not, the associates name and firm should be Googled, if able to locate, then the associates firm (work) email address Link should be added to **"column H Email". **If not able to locate (the associate is not longer at the firm) **"column H Email"** should be left blank.