Organize 1000 Entries Email Database For Mass Send

The problem of this database is that, there are: - Names of key people - Titles - Emails only the Names of the Key People and Titles are 100% sure to correspond to each other. For the emails, sometimes they do, sometimes they don't. Your task is to choose which Key Person are we going to address on the email considering the following factors: 1. Title Hierarchy 2. Is the email direct? EXAMPLE: Dr. João Martins Director Geral-CEPO Dr. Miguel Queiroz Director Inovação e Desenvolvimento do grupo at Zahara SGPS Dr. Sérgio Nunes Responsável Central de Compras Alimentar Dr. Filipe Guilherme Responsável Central Compras não Alimentar Available emails: geral@[login to view URL] [login to view URL]@[login to view URL] [login to view URL]@[login to view URL] TASK: 1. Decide who to address 2. On the cell with the names, erase all the names that we are not going to address 3. Organize email collumns so that the person we will email has his email on the first or second email collumn SEE EXAMPLE: Please see spreadsheet example. There are 15 untreated, 3 treated. Please test-treat the untreated 12 lines and send back. I will be online for your questions. As soon as you show me you got it, I'll pass you the 1000 line database.