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?
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
 
P

petergroft29

New Member
Outlook version
Outlook 365 64 bit
Email Account
Exchange Server
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
 
Diane Poremsky

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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
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
Rupert Dragwater Background colors not saving in Outlook 365 Using Outlook 11
petunia Outlook tasks module sunsetting? Exchange Server Administration 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 1
D Outlook VBA forward the selected email to the original sender’s email ID (including the email used in TO, CC Field) from the email chain Outlook VBA and Custom Forms 3
U Outlook 2021 not showing contact cards in Searches Using Outlook 2
C Outlook - Macro to block senders domain - Macro Fix Outlook VBA and Custom Forms 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
J Outlook 365 html inline images Using Outlook 1
Rupert Dragwater How to get Outlook 365 to open from websites Using Outlook 5
S Why do I have to close and reopen Outlook for macros to work? Outlook VBA and Custom Forms 2
J Outlook 2021 ScanPST errors (yet again ... sorry): repair button missing Outlook 2021 Using Outlook 0
HarvMan Outlook 365 - Rule to Move an Incoming Message to Another Folder Using Outlook 4
K Moved pst to new computer, now Gmail not coming into Outlook Using Outlook 7
S Email Macros to go to a SHARED Outlook mailbox Draft folder...NOT my personal Outlook Draft folder Using Outlook 2
F Running Scripts in Outlook 2021 Using Outlook 0
Nufc1980 Outlook "Please treat this as private label" auto added to some emails - Help. Using Outlook 3

Similar threads

Top