Contact data mappings

The mappings in the table below are used to synchronize contact data between Outlook and Sage CRM in Classic Outlook Integration.


Outlook	Sage CRM (Translation)	Sage CRM (Column)
Title	Salutation	pers_salutation
First	First Name	pers_firstname
Middle	Middle	pers_middlename
Last	Last Name	pers_lastname
Job Title	Title	pers_title
Company	Company Name	comp_name When Outlook information is synchronized with Sage CRM, the company name is deduped before any contact information is added to Sage CRM.
Street If an Outlook contact address is more than four lines long, the additional lines are concatenated into the Sage CRM address line 4.	Combines Address 1, Address 2, Address 3, and Address 4.	addr_address1 addr_address2 addr_address3 addr_address4
City	City	addr_city
State/Province	State	addr_state
Zip/Postal Code	Zip Code	addr_postcode
Country/Region	Country	addr_country
Business Phone Country/Region	Business Country	pers_phonecountrycode
Business Phone City/Area code	Business Area	pers_phonareacode
Business Phone Local number	[Phone/Email] Business	pers_phonenumber
Business Alternative Country/Region	Alternative Country	pers_faxcountrycode
Business Alternative City/Area code	Alternative Area	pers_faxareacode
Business Alternative Local number	[Phone/Email] Alternative	pers_faxnumber
Home Phone Country/Region	Home Country	vPhoneHome.Phon_CountryCode
Home Phone City/Area code	Home Area	vPhoneHome.Phon_AreaCode
Home Phone Local Number	Home Number	vPhoneHome.Phon_Number
Mobile Phone Country/Region	Mobile Country	vPhoneMobile.Phon_CountryCode
Mobile Phone City/Area code	Mobile Area	vPhoneMobile.Phon_AreaCode
Mobile Phone Local Number	Mobile Number	vPhoneMobile.Phon_Number
Email	[Phone/Email] Business	pers_emailaddress
Web page	Website	pers_website
Department	Department	pers_department
Categories	[hardcoded in Outlook to CRM Contact. Only updated in Outlook]