Accessing ALL Outlook contact fields

Status
Not open for further replies.
M

MacKenSee

New Member
Outlook version
Outlook 365 32 bit
Email Account
IMAP
I run Outlook (Office 365/ Microsoft 365) both in MacOS and Windows (virtualized), but mainly on the Mac. Available Contact fields differ somewhat between the two, but I assume that the data still is saved in the cloud. I have not been able to export contacts into a CSV file on the Mac side, and unfortunately not all fields are exportable in Windows. I have even tried (in Windows) listing all my contacts with all fields showing as columns, then selecting all of the contacts and fields to copy into Excel. However, the fields do not remain correctly lined up in Excel after copying.

I previously used ContactGenie (which I loved) to export but it is no longer compatible with Microsoft 365.
1. Does anyone know of utilities or VBA code that can export as well as re-import all fields?
2. Are there any third-party applications that can sync all contact fields to an IOS (iPhone or iPad) - for example, the "Referred By" field is very important to us, but I cannot access it while using Apple products. All CRMs that I have investigated only allow a subset of Contact fields to sync.
3. Does Microsoft provide any tools, APIs, etc that would allow a 3rd part party programmer to access and sync ALL fields?
 
MacKenSee said:
However, the fields do not remain correctly lined up in Excel after copying.
Click to expand...
This should only happen in multiple line fields when you copy and paste. But... for contacts, all fields should be exported (except custom fields). What fields are not exported?


3. no.
 
In the message, on the Message tab, in the Names group, click Address Book. In the Address Book list, click the address book in which you want to search for names. For the Search box, click More columns. Type the information, or part of the information, that you are searching for.

Hope You Find This Useful,
Peter
 
BTW - forgot these earlier:
MacKenSee said:
1. Does anyone know of utilities or VBA code that can export as well as re-import all fields?
Click to expand...
I have some VBA code samples, but they don't cover every field. Adding the fileds would be easy enough, but you need to do it. :)
This one imports the calendar but would be easy enough to fix to use contacts
www.slipstick.com

Create Appointments Using Spreadsheet Data

Use an Excel macro to create appointments in Outlook calendars. Type the appointment data into the spreadsheet then run the macro to create appointments.
www.slipstick.com www.slipstick.com

Export - this is email but gain, its not a biug deal to change the item type.
www.slipstick.com

Macro to Export Outlook Fields to Excel

Use a macro to write Outlook values to an Excel spreadsheet.
www.slipstick.com www.slipstick.com

and the no-export way -
www.slipstick.com

The No-Export way to use Outlook data in Excel

The no-export way to use Outlook data in other applications, such as Excel or Notepad.
www.slipstick.com www.slipstick.com


MacKenSee said:
2. Are there any third-party applications that can sync all contact fields to an IOS (iPhone or iPad) - for example, the "Referred By" field is very important to us, but I cannot access it while using Apple products. All CRMs that I have investigated only allow a subset of Contact fields to sync.
Click to expand...
No, none that I'm aware of.

MacKenSee said:
I have not been able to export contacts into a CSV file on the Mac side
Click to expand...
The mac version does not support exporting to CSV. Outlook on the web can export, but I don't believe it exports all of the fileds in outlook desktop (because on the web version doesn't support all of the field).
 
Status
Not open for further replies.
< Help me create a Macro to make some received emails into tasks? | Move emails from one account to another >
Similar threads
Thread starter Title Forum Replies Date
G Issues with accessing Outlook Contact Picture with VBA Outlook VBA and Custom Forms 4
K Accessing contact's custom properties in a Outlook 2007 form region Outlook VBA and Custom Forms 1
RBLampert Accessing Outlook accounts from multiple computers Using Outlook 8
E Accessing shared outlook folder doesn't work since switch to new outlook/excel Outlook VBA and Custom Forms 11
S Outlook [Online - Office365] perfomance is getting affected when accessing the mails using Redemptio Using Outlook 1
J Accessing Hotmail accounts with Outlook 2016 Using Outlook 3
n2b Accessing Plain Text Draft Without Outlook Using Outlook 3
P accessing custom task pane with Outlook ActiveInspector Using Outlook 1
mikecox Accessing Outlook on my Win7 desktop from Win8 laptop Using Outlook 1
S Programmatically accessing Outlook Calendar data Using Outlook 1
H Accessing a control on a frame in Outlook with VBScript Outlook VBA and Custom Forms 1
K Programmatically accessing Outlook properties Outlook VBA and Custom Forms 3
A Accessing .pst folder in outlook using VBA Code Outlook VBA and Custom Forms 4
J Outlook closes when accessing History in BCM BCM (Business Contact Manager) 4
B Accessing Outlook 2003 Signature Programmatically using C# Outlook VBA and Custom Forms 6
L Outlook Forms-Accessing Outlook VBA and Custom Forms 1
V Outlook custom form - installing and accessing Outlook VBA and Custom Forms 1
A Accessing full contact forms Using Outlook 2
S Problem Accessing .MSG Property 'ImageNaturalHeight' Tag '0x80010003' Outlook VBA and Custom Forms 1
J Accessing calendar items for Resource Mailboxes Outlook VBA and Custom Forms 2
M Accessing ExpiryTime property Outlook VBA and Custom Forms 1
M Accessing BCM with Excel / Running Reports BCM (Business Contact Manager) 1
C Problem accessing events for folder "username" Server Threw Exception Using Outlook 1
A "Unable to display the folder" error when accessing Group mailbox Using Outlook 0
Commodore Accessing mail from multiple devices Using Outlook 1
E Accessing User Defined Fields in BCM Database part 2 BCM (Business Contact Manager) 0
E [SOLVED] Accessing User Defined Fields in BCM Database part 1 BCM (Business Contact Manager) 9
R Accessing folder 'Other Contacts' Outlook VBA and Custom Forms 1
E Accessing a Form Region from an Inspector Outlook VBA and Custom Forms 3
E Accessing a Form Region from an Inspector Outlook VBA and Custom Forms 3
D Accessing Global Address List details with VBA Outlook VBA and Custom Forms 1
K assistant accessing from her home computer BCM (Business Contact Manager) 2
C Accessing _RecipientControl1 (Assigned To) Outlook VBA and Custom Forms 2
A Daily hours of recurring/ multi-day appts, & accessing mult calend Outlook VBA and Custom Forms 2
R New users creating get page cannot be displayed when accessing OWA Exchange Server Administration 16
C Outlook classic via 365 Using Outlook 1
Dr. Demento Analogous Outlook code to read info into an array (or collection or whatever) Outlook VBA and Custom Forms 7
S Repair Outlook Using Outlook 7
V Outlook Form ListBox is not editable Outlook VBA and Custom Forms 2
F Outlook's contacts Using Outlook 1
D Outlook 2003 stopped dead Using Outlook 2
G Cannot receive emails from gmail account in Outlook 365 Using Outlook 1
E "Cannot display the folder. MS Outlook cannot access the specified file location" Using Outlook 5
P Outlook 2016 Working Offline Using Outlook 2
Rupert Dragwater Cannot reestablish gmail (email address) account in Outlook 365 Using Outlook 11
O Outlook 365 synchronisieren Exchange Server Administration 1
kburrows Outlook Classic - JPG files are corrupted when opened or saved Using Outlook 3
F Sync Outlook Calendar Using Outlook 0
G Change default font size in sticky notes - Outlook Desktop 2021 Using Outlook 2
C VBA in "New Outlook?" Using Outlook 0

Similar threads

Back
Top