Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Notes Database: Manipulating Word 97 fields

Status
Not open for further replies.
mmtraining

mmtraining

IS-IT--Management
Mar 18, 2002
104
DE
Hello World. :)

We have a database, constructed using Lotus Domino 5. In a document we have an embedded Word 97 document which contains a number of fields. In the Lotus Notes document are fields which contain information we would like to hand on to the Word document every time the Notes document is opened.

I was thinking of taking the information from Notes and sticking it into the document properties in the Word document. What do you think? Any idea how to do this or any better idea?

TIA

Carol
Berlin, Germany
 
Sort by date Sort by votes
I have done something similar using Excel. Try opening an OLE connection (here's the Excel code I've used).

Set excelapp = createobject("excel.application")
excelapp.visible = False
excelapp.Workbooks.add("O:\PreTrialForms\InterviewReport")
Set excelsht = excelapp.Workbooks("InterviewReport1").Worksheets("InterviewReport")

Then I set individual cells in excel with the info from the document

excelsht.cells(2, 3).value = doc.DocketNo

Hope this helps.

la
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pmonett
  • Locked
  • Question
Script to make a PDF from a Word document - execution issues
Replies
0
Views
841
pmonett
pmonett
bmjones2
  • Locked
  • Question
Lotus Notes Teamroom - lotusscript table text/cell color
Replies
0
Views
813
bmjones2
bmjones2
TheAtomic
  • Locked
  • Question
Excel and Notes Email question
Replies
1
Views
820
pmonett
pmonett
australia3
  • Locked
  • Question
making fields appear in other databases
Replies
1
Views
197
PanelMaker
PanelMaker
samirm
  • Locked
  • Question
System time based searching in Lotus Notes
Replies
1
Views
225
pmonett
pmonett

Part and Inventory Search

Sponsor

Back
Top