About This Code
Brief Description:
Transfer Fields Value to Word Document
Contributor:
Andrew Jones
Last Modified:
17 Jun 2002
OpenNTF Disclaimer
All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.
Code / Description
Sub Click(Source As Button)
Dim workspace As New NotesUIWorkspace
Dim uidoc As NotesUIDocument
Dim doc As NotesDocument
Dim item As NotesItem
Dim wApp As Variant
Dim wDoc As Variant
Set uidoc = workspace.CurrentDocument
Set doc = uidoc.Document
Set wApp = CreateObject("Word.Application")
wApp.StatusBar = "Creatin document, plese wait..."
wApp.Visible = True
wApp.Documents.Add
Set wDoc = wApp.ActiveWindow
wApp.StatusBar = "transfering data, please wait..."
Forall i In doc.Items
Set item=doc.GetFirstItem( i.Name )
Call wApp.Selection.TypeText(i.Name)
Call wApp.Selection.Typeparagraph
Call wApp.Selection.TypeText(item.Text)
Call wApp.Selection.Typeparagraph
Call wApp.Selection.Typeparagraph
End Forall
wApp.StatusBar = "Data were successfully transfer."
End Sub
Usage / Example