I need to know if notes can integrate with MS Word and pass parameters to MS Word document.
Subject: Absolutely.
I’d suggest you contact/hire a Business Partner to help you with this. Some of the best (sorry, I don’t mean to leave anyone out) on this topic are:
http://www.johndavidhead.com/jhead/johnhead.nsf?Open
http://www.lotusgeek.com/SapphireOak/LotusGeekBlog.nsf
Here you can download Rocky’s presentations on the topic: http://www.sapphireoak.com/sapphireoak/sapphire.nsf/Downloads?OpenView
Subject: 3rd party tool: Integra
Besides inventing the wheel all over again, you can also turn to a number of 3rd party tools, which allow you to set up the linkage in a way that makes sense to you.
Our tool, Integra for Notes, is a native Notes reporting tool, which also allows for importing, scheduled reports, automatic PDF-creation and even saving the endresult back into Notes (if so desired)
Free demo at www.integra4notes.com
Subject: Great point, there are some excellent partner products out there…
here are a few… (again, sorry if I left anyone out, please feel free to tell me, I’ll update my list)
Integra - http://www.integra4notes.com
IntelliPRINTPLUS & IntelliVIEW - http://www.intelliprintplus.com/
Print Merge Express - http://www.printmergeexpress.com
SNAP! Reporter & SNAP! Editor - http://www.paisleyconsulting.com/paisleyhome.nsf/vwMain/Product?OpenDocument
SWING Integrator & SWING InOffice - http://www.swingsoftware.com/
Subject: RE: Great point, there are some excellent partner products out there…
Hi Alan,
Any list of reporting solutions for Lotus Notes and Domino should include this one: Microsoft SQL Reporting Services + Proposion Report Adapter for Lotus Notes.
Microsoft SQL Reporting Services is a new reporting tool that competes with Crystal, etc. It is an amazingly popular product, partly because if is now free your SQL Server license. I was amazed at how many people I met at Lotusphere who were already using it.
Anyway, Proposion Report Adapter is an add-in that turns Microsoft Reporting Services into a great reporting/charting tool for Lotus Notes databases. Our extension knows all about the “weird” things in the Notes world like attachments, images, multi-valued items, and access control rules. In addition, we add the option of delivering reports (regardless of the data source) to subscribers via native Notes mail and/or depositing scheduled reports into Notes databases (which allows users to build cool report archiving/workflow/distribution applications).
See Products A-Z for details.
Subject: Will happily add it to my “unofficial list”
Subject: MS Word integration
Try this, I think you can use much of the codehttp://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/33dc7a836bdabea585256f0a00640942?OpenDocument
Subject: RE: MS Word integration
This is dead simple. Create a document in Word, add bookmarks that have the same name as your notes fields, compare the two and call the below function when you find a match:
Function SetBookmark( wordDoc As Variant, fieldName$, itemValue$ ) As Integer
’ Set’s the value of a bookmark in a Word document
On Error Goto errorHandling
Set range = wordDoc.Bookmarks( fieldName$ ).range
range.end = range.end - 1
range.text = itemValue$
SetBookmark = True
Exit Function
errorHandling:
Print “Attachment.SetBookmark reports:”
Print "Bookmark: " & fieldName$ & " - Value: " & itemValue$
Print Cstr(Err) & " " & Error$
SetBookmark = False
Exit Function
End Function