SWING InOffice Overview

MS Office integration add-on for Lotus Notes

SWING InOffice is a tool that bridges the gap between Lotus Notes and Microsoft Office. It improves office productivity and reduces the burden on IT, by integrating MS Office with Lotus Notes databases and email.

What can you do with SWING InOffice?

• Create Office documents with Notes data
• Report, chart and analyze Notes data
• Mail merge and labels
• Send documents and reports as PDF
• Store Office documents and reports into Notes databases
• Import documents and spreadsheets
• Create Group Calendar reports and charts

Create Office documents with Notes data

SWING InOffice lets users bind Office templates with any Notes database. It allows users to easily populate Office document templates with Notes data (e.g. creating Purchase Orders in Word or Excel, using data from a Notes database).

Using Microsoft Office rich formatting and printing capabilities, Notes users are able to overcome the limited printing and reporting functions in Lotus Notes, leveraging their existing skills and investments.

Report, chart and analyze Notes data

Transform any Notes view into Excel reports and charts. Create your report layouts once, store them in the InOffice template repository, and use them many times.

SWING InOffice eliminates the laborious process of manually inputting data into spreadsheets and updating it on a regular basis. All Excel formatting and calculations are preserved when the report data is updated.

Create compound reports, using data from multiple Notes databases. Take advantage of advanced features in Excel such as PivotTables, conditional styling, and drilldown to analyze Notes data without having to purchase specialized OLAP tools.

Mail merge and labels

Perform personalized mass mailings in the form of emails, PDFs, faxes, and printed documents. Easily merge an Office template with contact data from Notes Address Books, or any other Notes contact management database.

Send documents and reports as PDF

Distribute Office documents and reports as universally accepted PDF files - with a single click. Empower all users to create PDFs, removing the need for any additional PDF tool.

Store Office documents and reports into Notes databases

Save created Word documents or Excel spreadsheets into Notes databases. Notes fields are automatically updated with the Office document properties and fields.

Import documents and spreadsheets

InOffice can be used for importing Office documents and spreadsheets into Lotus Notes databases. It transforms data structures such as master/detail Excel forms (e.g. Travel Expense Report) into Notes documents, either as main/response documents, or multivalue fields. For the end-user, it takes only a single click in the InOffice wizard to perform such an import operation.

Create Group calendar reports and charts

SWING InOffice 2.1 adds Group Calendar report templates. Using these templates, InOffice collects shared calendar data from specified team members, and shows them in a single consolidated view in Excel. In addition, InOffice enables further time and activity analysis, taking advantage of Excel PivotTables, reports, and charts.

Screenshot: InOffice Main menu

It's simple to get started!

Following our Quick Start Guide, you will be able to understand the product and see many of its features in less than half an hour. A rich collection of real-life samples helps you become productive instantly. The collection includes ready-to-use templates such as NAB Phone Directory, Group Calendar report, Purchase Order, Sales Quotation, Invoice, Expense Report, Health Expenses Reimbursement Form, Sales Letters, Sales Analysis, Activity Analysis reports, and more.

Samples include document templates from Business-in-a-Box™ by Envision SBS.

Next: Features