First, I need to create a form which will automatically populate contact details from Outlook. I have used http://www.msoutlook.info/ as a guide. Now I want to create a macro which will automatically bring up this address book, have the user select a name from the contact list, and then reformat it by removing the spaces.
Problem I have is that as soon as the address book dialog box opens, I am not able to pause the macro so that the user can make the selection.
Any helpful tips on how I can automate this? The end goal is that the user does not want to cut and paste the customer data from the address book into a form I am creating. The link above seems to be the only way to select a contact from Outlook, but the user wants the form completely automated -- he doesn't want to have to remember how to call up the address book.