Pull business card from Outlook Contact into Attachment (or OLE) field in Access with VBA
Posted on 2011-04-19
Due to 8 years of mis-managed contacts, I am trying to clean up a clients contacts. There is no way I can see to do this (due to the mess it is in, over 5,000 contacts with wrong data in wrong fields, company names spelled differently in multiple contacts, etc.). So I am trying to bring all his info into Access where I can 1) store a back-up of his contacts with all information, that I can easily manipulate 2) clean-up contacts and re-import into Outlook.
However, I do not know how to grab an attachment with a contact (ie: business card) and bring it into an access field set as either "attachment" or "OLE" (I am dealing with Access and Outlook 2010)