CRM-Outlook Field Mappings - Microsoft Dynamics 365 Blog

Ever wondered what fields in Outlook map to what fields in CRM? Wonder no more. (NB: In the current versions, these mappings are not customizable or extensible.)

Field in Outlook	Field in CRM
Task
Body	description
Due Date	scheduledend
Priority	priority
Start Date	scheduledstart
Status	computed from Activity State Code and Appointment Status Code
Subject	subject
Unsynchronized Outlook fields include: Reminder, Contacts, Categories, Privacy Flag, Date Completed, Total Work, Companies, Mileage, Billing Information
Appointment
All Day Event	isalldayevent
Body	description
Duration	scheduleddurationminutes
End	scheduledend
Location	location
Optional Attendees	optionalattendees
Organizer	organizer
Priority	priority
Required Attendees	requiredattendees
Show Time As	computed from Activity State Code and Appointment Status Code
Start	scheduledstart
Subject	subject
Unsynchronized Outlook fields include: Label, Reminder, Contacts, Categories, Privacy Flag, Importance Flag
Contact
Anniversary	anniversary
Assistant Name	assistantname
Assistant Telephone Number	assistantphone
Birthday	birthdate
Body	description
Business Fax Number	fax
Business Telephone Number	telephone1
Children	childrensnames
Department	department
Email1Address	emailaddress1
Email2Address	emailaddress2
Email3Address	emailaddresss3
First Name	firstname
FTP Site	ftpsiteurl
Government ID Number	governmentid
Home Telephone Number	telephone2
Job Title	jobtitle
Last Name	lastname
Mailing Address City	address1_city
Mailing Address Country	addresss1_country
Mailing Address Post Office Box	addresss1_postofficebox
Mailing Address Postal Code	address1_postalcode
Mailing Address State	addresss1_stateorprovince
Mailing Address Street	address1_line1; address1_line2; address1_line3
Manager Name	managername
Middle Name	middlename
Mobile Telephone Number	mobilephone
Nickname	nickname
Other Telephone Number	telephone3
Pager Number	pager
Spouse	spousesname
Suffix	suffix
Title	salutation
Web Page	websiteurl
Yomi First Name	yomifirstname
Yomi Last Name	yomilastname
Unsynchronized Outlook fields include: Photo, IM Address, Other phone numbers, Office, Profession, NetMeeting Settings, Free/Busy Server Settings

Interesting story: We managed to release three versions without anyone really asking for this info. Then, in recent months, a deluge of requests came in. The truth is that we didn’t have it – if it ever existed, it was lost in the sands of time. These excuses didn’t go down well, someone pointed out quite snidely that creating it would be the work of a few minutes for someone with access to the code. So one day, no doubt I was procrastinating about something even more painful, I sat down and did it. It wasn’t the work of a few minutes. It took about three hours of wading through code and the help of two devs. Thanks to Elliot Lewis and Navin Thadani!

– Ilana Smith.

Tags