How do i convert a column of email address in excel to a useable list in outlook? notes:. these instructions work for both pc and mac computers, using outlook or outlook web access.. I have an array of values. i want to show those values in excel cell as drop down list using vba. here is my code. it shows "type mismatch error!" dim xlvalidatelist(6) as integer xlvalidatelist(…. Purpose . this example demonstrates how to send email to a list of email addresses contained in a microsoft excel spreadsheet. additional prerequisites.