Search DominoPower's 10,675 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
PRODUCT REVIEW
How to easily connect Notes and Microsoft Office
By Benoit Duboc

It all started when we had to replace our contact management system. They system we had was not up to date and we had stability issues due to the number of contacts we had. It was clear we needed to do something. One of the neat features we had in the old application was that, from a contact record, we could start Microsoft Word and start writing a new letter from a company template and the application would transfer contact information into the Word document. Try taking that out of the hands of the end users!

The integration between Notes and Microsoft Office got me thinking: there must be an easy way to integrate both products without having to write tons of OLE (Object Linking & Embedding) code. That's where SWING Office Integrator 3 comes in.

I first read the product description on their Web site (at http://www.swingsoftware.com). In addition to linking Notes to Word, SWING can also link to Excel and integrate all other Office documents, as well as other types of documents. This was great because it offered possibilities for fixing some issues we had in another project. I'll give more details on that later. I then downloaded their sample document library application, which claims to be very easy and demonstrates exactly what the product is doing. I said to myself: "Yeah, yeah, we all heard that one before. We'll see."

A nice surprise
After unzipping the sample document library application and scrolling through the very complete documentation (a PDF file that includes a walkthrough of the sample document library application as well as a complete listing of all the functions/procedures available in SWING), I had my first surprise, and it was a nice one. All elements needed for the integration of Notes and Office were self-contained in a Notes database. This means a client installation on every single PC where the application might be used wasn't necessary. This was a major thing for us, as we have offices across Canada and support varies a lot from one office to another. No DLLs (Dynamic Link Libraries) to install, no additional program running, just plain Notes.

"If you're looking for some integration between Notes applications and Office documents and you want the simplest and fastest solution around, SWING is the product that you definitely need."

I then started working on integrating one of our templates in their sample document library application. The process is fairly simple: you add your template to a Notes document, which resides in a "template" view. Our template was not modified at all, as it already contained the fields needed for a mail merge. In that same Notes document, you match the fields from the Word template and the Notes form you want the data from. Again, all is done in the Notes client, under one Notes document. Could it be simpler? And because all of this is done once in a Notes document, it's a breeze to have "template managers" that will be responsible for matching field names, creating and updating the Office templates. The end users will only have to click the right button from the right Notes document, according to what type of Word document they want to create for a specified contact or list of contacts.


1  ·  2  ·  3  ·  Next »
Other articles you might like
Home > Reviews and previews (85 articles)
   Using Balsamiq Mockups to create low-fidelity prototypes
   Exploring VMWare Workstation
   Four Notes admins put Department Calendar to the test
Home > Microsoft Technologies > Office (6 articles)
   Quick guide to using the Microsoft Outlook 2002 Connector with a Domino server
   Integrating Domino with Office 2000 via XML
   How to query Domino from within Excel
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
What to look for in a Domino-based document management solution
Understanding Domino.doc end-of-life options
When the debugger won't debug hidden code that isn't hidden
What to do if the LotusScript debugger won't single-step over code
Top 10 ways to launch and build a Lotus consulting practice (with a little help from the Beatles)
Troubleshooting an OpenSuse Notes install
Incident report: denial of service attack against ConnectedPhotographer.com
Latest Lotus Headlines
SnTT - Enabling ALL the bells and whistles!
Tivoli Data protection causes Domino to crash
Fun when running DB2 CLP scripts
Introducing Flippr, the easy way to admin Quickr
DXL and fake security
Using search forms in IBM Workplace Collaborative Learning 2.7
Schmidt, Freed, and Gering on the OVF Toolkit
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Eight steps to successful and reliable home backups
David Gewirtz Online: CNN commentary and analysis
OutlookPower: Can Outlook run when it's not running (and other mysteries)?
-- Advertisement --

PDF Conversion for Lotus Notes
Convert Lotus Notes documents to PDF for sharing, archiving or web printing.

  • 1-step PDF: As easy as clicking a Lotus Notes toolbar icon
  • Archive email folders or views as a self-contained PDF
  • Convert any document collection into a PDF file
  • Produce print-quality output from Web applications
  • Client side or Server side conversion
  • Doesn't require any DLL files
  • LotusScript API for developers


Ready to learn more?
-- Advertisement --

Good Practices... Better Practices... Teamstudio.
Implementing good practices in your Notes environment doesn't have to be complicated.

Teamstudio provides software and services for efficient Notes development and simple, secure administrator control. Our new website also provides users with a library of resources to help, including:

  • Ready-to-implement policies for good practice development and deployment in Lotus Notes
  • On-demand webinars on topics ranging from tips for better coding, to securing your applications, managing agents, and streamlining your application deployment process
  • Free utilities for download to help you more more efficiently tackle several specific tasks in Notes development
Visit our library of white papers to help you take on difficult issues in your Notes environment.

Drop by our new website and take a look!
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2009, ZATZ Publishing. All rights reserved worldwide.