Adding a contact to Outlook with a custom form using Access VBA

Outlook version
Outlook 2013 64 bit
Email Account
Outlook.com (as MS Exchange)
I have a Access 2013 database that saves Contacts to Outlook. It works fine but a lot of the contacts have two business phone numbers. I assign values to both the Business... and the Business 2... fields and it but the Business 2... field is not one of the default phone number fields that are displayed on the standard Contact form (you have to drop the list of phone number types and select "Business 2" for it to be visible. I couldn't find a way to accomplish this via VBA. I then thought of creating a custom contact form so I could set different defaults. This works great when adding contacts manually in Outlook... but in Access VBA my contact creation code, using .CreateItem(olContactItem) for my fields, keeps using the standard form. Is there a way to select the form for my contact creation to use using VBA? I am publishing it to Personal Forms Library, Outlook Folders, and Contacts. Or is there a better way to change the types of phone numbers that are displayed by default. Any advice would be greatly appreciated.
 

Similar threads

Top