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 I don't understand Outlook or Microsoft, anymore Using Outlook 1
P My Feedback to Microsoft and their response; also New Outlook roadmap Using Outlook 0
A New Outlook - Cannot drag IMAP emails to Task List in MyDay Using Outlook 1
L Android Outlook Doesn't Update PC Notification Changes Using Outlook 0
A How to open Excel file saved in Outlook folder? Outlook VBA and Custom Forms 4
D.Moore Outlook desktop client suggested searches question Using Outlook 22
Y Outlook 2016 (64-bit) Copy Local Cal. Events to Another Cal. with Modified Reminder time Using Outlook 2
T Outlook 2019 While connecting an IMAP account in "classic" Outlook 2024 I caused a massive duplication of emails on the server (death loop) Using Outlook 5
D Cannot logon to Outlook.com, or outlook on Mac, outlook not updating on ipad, iphone Using Outlook 1
J unable to get my new install of Outlook to display mailboxes in the single-line format. Using Outlook 1
D Legacy Microsoft Outlook for Mac Support will end in Oct 2025 Using Outlook 5
C Nasty Bug Lurking In Outlook For Years. The Trigger. Any Fix Or Workaround? Using Outlook 11
R Auto clicking Hyperlink in outlook Outlook VBA and Custom Forms 7
ughlook Open multiple contacts in NEW Outlook? Using Outlook 3
G Outlook translation feature is off Using Outlook 2

Similar threads

Back
Top