To ensure the work email is unique to the employee's person record, follow the steps below.
In the Admin Tool, click Import/Export Data.
Click Create an export definition then click Select the data to export.
Change the database to SelectHR then log in.
Copy the below SQL code:
SELECT ALL TOP 100 PERCENT Person.Details.[Person Number], Person.Details.[First Name], Person.Details.Surname, Person.Details.[E-Mail], Person.Details.[Private E-Mail], Person.Snapshot.[Effective Status] FROM Person.Details INNER JOIN Person.Snapshot ON Person.Details.[Person Number] = Person.Snapshot.[Person Number] WHERE Person.Details.[E-Mail] IS NOT NULL ORDER BY Person.Details.[E-Mail]
Click Options, then select Paste SQL from clipboard.
Change the First Name and Surname criteria to match the First and Surname of the employee.
Click Data.
If the employee appears twice and the record with the higher Person Number numerically has the correct email details, update your employee's email address.