Outlook Address Book contact import from Excel.
HOW TO IMPORT OUTLOOK GLOBAL LIST FROM WITHIN EXCEL In one of my projects, I needed to import information from outlook into excel. To take on this task, i needed a intro lesson to macros. What will this macros code do? The macros code will be activated before right click activity. Once the macros is activated, it will pull up the Global Address Book, there you can search your directory of contacts then select add. Your selection will import that contact (in my case i would just the name, but you can do email and other attributes) . The following is what i would like it to do: Here you have the excel sheet, the red area is where i would like to fill a name. I will select that cell, then right-click. With the right click the Address Book will pop up. Once you have the address book up, you can select the name you would like to fill. Then click add. In this screen shot you can see that the selected cell has been filled. H...