giusepe
asked on
Export Notes Documents to Word
I need to export documents contained in views to Word, according to LotusScript this is possible with OLE. I need the CODE to do this or where can i find sample CODE to Export TO WORD. URGENT.
To have an idea of the documents and the database i am working on, this is for more detail:
I am working in a database in Lotus Notes and i need to create a document in Word with the information contained in different views of the database.
The structure of the documents in the database are: there are documents type Document, Response and Response to Response. What i need is create a document in Word where i can obtain the informaion in that Notes database.
Is it possible to create such document in such a manner that when the datbase in updated, the docuemnt is updated also?
I have been trying exporting the views to an ascii file and then open that file in Word, but such document can not be updated automatically. Also i have used an ODBC to catch the information, but because of the structure in the types of documents ( response, response to response ) the tables in Access are separated and can not obtain the information of the documents properly.
Is there any way that you know where i can create a Word document with the information contained in the Notes Database (Views )and make that document updated when the database changes or maybe create an agent to do this?
DATABASE
VIEWS
DOCUMENTS ( Document, Response, Response to Response )
.......
.......
.......
.......
.......
....
..
..
Word Document ( Updated )
I will be very thankfull with all the ideas that you can provide me to solve this.
Thanks.
To have an idea of the documents and the database i am working on, this is for more detail:
I am working in a database in Lotus Notes and i need to create a document in Word with the information contained in different views of the database.
The structure of the documents in the database are: there are documents type Document, Response and Response to Response. What i need is create a document in Word where i can obtain the informaion in that Notes database.
Is it possible to create such document in such a manner that when the datbase in updated, the docuemnt is updated also?
I have been trying exporting the views to an ascii file and then open that file in Word, but such document can not be updated automatically. Also i have used an ODBC to catch the information, but because of the structure in the types of documents ( response, response to response ) the tables in Access are separated and can not obtain the information of the documents properly.
Is there any way that you know where i can create a Word document with the information contained in the Notes Database (Views )and make that document updated when the database changes or maybe create an agent to do this?
DATABASE
VIEWS
DOCUMENTS ( Document, Response, Response to Response )
.......
.......
.......
.......
.......
....
..
..
Word Document ( Updated )
I will be very thankfull with all the ideas that you can provide me to solve this.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
place after:
WordObj.fileSaveAs "myNew" & i & ".doc"
this statement:
wordObj.fileClose
and after the "next" loop end close word with this:
Set WordObj = Nothing
So, now your question how to update docs in a folder; well, you have to have any criteria in your notesdocs what the name of worddoc should be.
The abowe action owerwrites yhe previous word.docs at next run time.
So you get your update. If you want to have it running electricaly, place the code to an agent, click on shareble box, give it selection: "If documents have been created or modified" and look at it...
Regards,
stamp