Export Lotus Notes Documents into MS Word 2000

Posted on 2005-04-28
Medium Priority
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
  • 2

Expert Comment

ID: 13888412
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

ID: 13888555
Do you mean use the VBA code in lotus notes to set the values?

Accepted Solution

HappyFunBall earned 1000 total points
ID: 13888994
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:\template.dot")
    '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
ID: 13889747
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 http://www.geniisoft.com

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

850 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