Export Lotus Notes Documents into MS Word 2000

Posted on 2005-04-28
Last Modified: 2013-12-18
Programing Question:  I need a code for Lotus Notes Script that would take a selected already saved lotus document and export it over to MS Word 2000 (i don't know if the version matter).  I need the document to look simular to the form used to fill out the document... Meaning I will probably have to go in and set the Word format in the program. Can anyone help?  
Question by:crystalsingleton
    LVL 9

    Expert Comment

    You could use the @Command([FileExport]) in an agent, rather than try to do this via Lotusscript.  

    Alternately, you might want to setup a Word Document template that looks like the particular form you're exporting.  Then you can use VBA to just set the values of fields on the Word template.  

    Author Comment

    Do you mean use the VBA code in lotus notes to set the values?
    LVL 9

    Accepted Solution

    Yes, here's a little code to get you started.  This isn't intended to be run, just to give you an idea what I'm talking about.  The following code in a Lotusscript agent could be used to get at a Word doc programmatically.  

        Dim vtWordApp As Variant
        Dim vtWordSelection As Variant
        Dim vtWordDoc As Variant
        'create document object
        Set vtWordApp = CreateObject("Word.Application")
        Set vtWordDoc = vtWordApp.Documents.Add("C:\")
        'Add variables
        Call vtWordDoc.Variables.Add ("date", "test")
        Call vtWordDoc.Variables.Add ("time", "test")
        Call vtWordDoc.Variables.Add ("location", "test")
        Call vtWordDoc.Variables.Add ("address", "test")
        Call vtWordDoc.Variables.Add ("phone", "test")
        Call vtWordDoc.Variables.Add ("email", "test")
        Call vtWordDoc.Fields.Update
        Call vtWordDoc.SaveAs("c:\HelloWorld2.doc")
        Call vtWordApp.Quit()
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Works, but you'll never get the rich-text fields to Word in the same format. A cut&paste approach from an open document might work, but is still a Very Clumsy Method (says Pooh). If it's to be done only a few times, then use a manual cut&paste procedure.

    For a proper solution, but only if you have a few $$ to spend, look into the Midas toolkit, on

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    This is an old article, please see an updated version of this article, located here:
    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now