We are looking to create a drop down list with excel that would contain our contacts in Outlook 2010. I've exported to a .csv file and placed on Sheet2. On sheet1 I chose the first column as the data source within the Data Validation section, but this just brings in the first name.
Say I have 100 contacts, I would like to hit the drop down list and choose their name, filling in the cell with relative contact information.
And if this is possible, is there a way to just pull it in from Outlook contacts via script or some other conenction?