Toronto’s Connector extraordinaire Sacha Chua developed this super-nifty Lotus Notes script which does a flexible mail merge from a Microsoft Excel spreadsheet to Lotus Notes, as documented and shared in Lotus Notes mail merge from a Microsoft Excel spreadsheet. Keep Continue reading Sacha Chua shares her Lotus Notes mail merge from a Microsoft Excel spreadsheet
I wanted to launch a excel (xls) file which was stored in a Profile document, from a Notes Client (tested in r8.5 but I see no reason this will not work in versions going back to r5) (Making it available Continue reading SNTT : using LotusScript to launch file attachements (EmbeddedObjects) in Lotus Notes
Hard coding is bad, bad , bad. Very bad, okay? (see Avoiding Hard Coding of Group Names). Here’s a quick and dirty way to have a drop down dialog which selects the “Year” and not be hard coded. 1234currentYear := Continue reading SNTT : Don’t hard code your Selectedable Years in a Lotus Notes dialog box.
The challenge was to have end users enter url’s (or uri’s) for content and have it presented as a link on the read only end part of the site. The problem is that means having “http” (or “https”) -which indicates Continue reading SNTT adding http onto URL strings in Lotus Notes
Previously, I showed how to globally Stop Copy and Paste, in Lotus Notes using formula language, at the database event level. I also mentioned how to allow some documents to be pasted in. (in the Notes Client) What if you Continue reading Stopping Copy and Paste, in Lotus Notes, selectivity in Views