By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
do you need to print a Notes document perfectly onto a preprinted form? There
are third party tools that do a nice job at this, but if you have only a few
different formats you need to handle and if your users have MS-Word, one option
is to use OLE automation to have Notes control a Word session and create a Word
doc based on the Notes document and print it. All without the user seeing
Word. One of the tricks is to use a template file (DOT file) with bookmarks,
which simplifies the script code. Some simplified code is below.
' ... set up all the Notes stuff, such as doc
' handle, etc.
' Create word doc using OLE automation
set objWord = createObject ("Word.Basic")
'Move word cursor to a bookmark
' Get a field from Notes doc
username$ = doc.userName(0)
' Push this field value into Word
' Goto next bookmark and do the same
phone$ = doc.Phone(0)
' Do this for all other fields you need in Word
' If you want, save Word doc to file
' Or print the doc
' and Close