Microsoft® Integration Package - R12

Overview – Microsoft® Integration Package

CMiC Microsoft Integration Package (MIP) is a component that allows the use of Microsoft Word® documents to easily create templates for MIP based form letters (MIP Word documents), and provides Word documents as output from MIP documents in order to touch-up or edit their output more easily. MIP also allows Microsoft Excel® worksheets, with or without macros, to be used as standard templates for the printing of specified data through CMiC’s Send-to-Spreadsheet feature.  Lastly, MIP provides integration between the Microsoft Outlook® calendar and CMiC contacts.

NOTE: MIP functionality achieved via ADF and JSP based screens.

The following are the features included within the Microsoft Integration Package.

Microsoft Word® Integration

  • Set up an unlimited number of Microsoft Word® documents to be used as standard form letter output to be printed from any screen within the CMiC software.

  • Use the existing CMiC Form Letter Definition screen to identify the data sources to be used as well as the relationships between the master and detail tables.

  • Merge standard text embedded within the Microsoft Word® documents with data stored anywhere within the CMiC database.

  • Easily position CMiC database fields on the Microsoft Word® documents using pre-defined place-holder values such as <<Project Name>>, <<Project Address 1>>.

  • Format pages as required, including paper size, margins, orientation, headers, footers, sections, tabs, and indents.

  • Allow for an unlimited number of format changes, such as bold, underline, italics, fonts, and font size changes, within each section or sub-table.

  • Embed an unlimited number graphics and images within the documents as desired.

  • Embed an unlimited number of sub-tables within each document as required, allowing for detailed schedules and lists to be inserted at any point.

Microsoft Excel® Integration

  • Set up an unlimited number of pre-formatted Excel® worksheets to be used as standard templates when using the CMiC Send-to-Spreadsheet feature.

  • Insert data into specified locations on Excel® worksheets on demand, allowing for dynamic spreadsheet updates.

  • Dynamically refresh Excel® charts and graphs, using the ability to update specific cells with updated data on demand.

  • Format target worksheets as required, including paper size, column widths, margins, orientation, headers, and footers.

Microsoft Outlook® Calendar Integration

  • Schedule calendar events in Microsoft Outlook® and synchronize them with action items scheduled within CMiC.

  • Create action items in CMiC and synchronize them with calendar events entered in Microsoft Outlook®.

  • Schedule and synchronize recurring events.

  • Update and synchronize event details and notes.

  • Synchronize both public and private action items.

Microsoft Outlook® Contact Integration

  • Synchronize all contact data from CMiC Project Management or CMiC CRM with Microsoft Outlook®.

  • Synchronize one’s own personal contact directory with the safe and secure CMiC contact database.

NOTE: Microsoft, Microsoft Office, Microsoft Word, Excel, Outlook, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
CMiC Microsoft Integration Package is an independent application and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation.