Home > Ask the CRM / Call Center Experts > Using Microsoft CRM Questions & Answers > How does Microsoft CRM 4.0 integrate with Microsoft Office?
Ask The CRM Expert: Questions & Answers
EMAIL THIS

How does Microsoft CRM 4.0 integrate with Microsoft Office?

Richard Smith EXPERT RESPONSE FROM: Richard Smith

Pose a Question
Other CRM Categories
Meet all CRM Experts
Become an Expert for this site


CRM and call center FAQs
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 15 January 2008
My company is shopping around for a CRM system. If we are already using Microsoft Office products, is Microsoft CRM 4.0 the best way to go, since it will easily integrate with Office?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


RELATED CONTENT
Using Microsoft CRM
Is Microsoft Dynamics CRM 4.0 and Lotus Notes integration possible?
Six Microsoft accelerators for Dynamics CRM 4.0
Microsoft eLearning courses for Dynamics CRM training
Linking Microsoft Outlook contacts to Dynamics CRM
The advantages of Microsoft CRM Online: Support, flexibility and cost
Technology requirements for a Dynamics CRM installation
Should we upgrade to Microsoft CRM 4.0?
Converting and linking leads in Microsoft Dynamics CRM
Multi-language deployments of Microsoft CRM
Is Microsoft Retail Management System (RMS) integrated with Dynamics CRM?

Evaluating CRM software
Three steps to maximize CRM functionality for small businesses
SearchCRM.com product directory library
Explaining SAP CRM and ERP integration techniques
What are the SAP enhancement packages for SAP CRM?
How to research small software vendors for CRM
Is on-premise CRM a bad investment given the growth of SaaS CRM?
CRM software for small businesses: Top headlines
CRM extending to more than just customer relationships
Tips for converting a lead to a contact in Microsoft CRM
Open source CRM tutorial
Evaluating CRM software Research

Microsoft CRM benefits
Microsoft CRM targets usability
Microsoft CRM Mobile benefits and functionality
Is Microsoft CRM a good option for five employees?
Microsoft Dynamics CRM 3.0 vs. 1.0
New Microsoft CRM chief targets SMB needs

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Quality of Experience  (SearchCRM.com)
sales cycle  (SearchCRM.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


When it comes to integrating with Microsoft Office, it's hard to beat Microsoft CRM. Microsoft has offered extensive integration since the first CRM release with an integrated Outlook client, dynamic Excel PivotTable exports and reports and Word mail-merge integration for letters and custom emails.

With Microsoft CRM 4.0, the integration with Microsoft Office is even better. Here are a few of the major Office-integration enhancements in the new release:

Ribbons: The new toolbar functions are integrated in the ribbons in Microsoft Office 2007.

Outlook: The Outlook toolbars now offer a quick list of recently selected records (accounts, contacts, etc.) for linking an Outlook email, appointment or task to a CRM record. Just about every CRM function, including administrative functions, can now be accessed through the Outlook client. There are improvements to synchronized Contacts and just about every type of task (phone calls, tasks, letters, faxes, etc.) can now synchronize with the Outlook Task list. Also, the change in the CRM infrastructure makes it possible for users to easily access CRM outside of the office without having to go through a VPN connection.

Excel: Users can still create dynamic exports and reports of data in CRM, but now they can select data from multiple CRM tables (entities) to be included in the export. There is also a function that allows data to be exported, edited in Excel and re-imported into CRM as updates. Excel workbooks can still be linked as reports to specific functional components of CRM.

Word: The mail-merge functionality has been completely overhauled. Users can select from a set of personal or organizational Word templates stored directly in CRM, so users have access to the same templates from the Outlook and Web clients. Like with the Excel exports above, data can be extracted from CRM to Word from either one or multiple tables (entities), making it easier to get the right data into the exports. Once the merge is complete, a copy of the merged document can be logged in CRM as a closed activity, and an electronic copy of the document will be linked to the appropriate CRM record.

Microsoft is committed to making Dynamics CRM work the way its customers work. The tight and comprehensive integration with Microsoft Office increases user adoption and productivity by integrating powerful customer management functionality with the tools that users already know and use to interact with their customers.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Expert CRM Reviews
CRM Webcasts
Sales force CRM

Find the right CRM solution according to your unique needs.
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts