After realising that a lot of people are ill-informed about Lotus Notes / Domino and its capabilities, I have established this blog (built on Lotus Notes!). With your help, I aim to set the record straight. Please help me redress the balance by sharing your experiences of Lotus Notes and posting all things good about the product - how you use it, how it helps you and how it helps your organisation.  Blog away!
Add Comment
Mike wrote
on Tuesday 08 August, 2017 at 20:11:07 UTC
I want to move web application to different directory on same server.

what is best practice ?

If I use move application feature , will that also redirect web users

Reply »
FMA wrote
on Tuesday 01 August, 2017 at 04:59:15 UTC
IBM Notes is a very powerful development platform for companies. It compliments legacy applications in Oracle, SAP and other third party applications. I hope this system will last for the next 25 more years! IBM wake up, this has helped developing nations like the Philippines go into paperless transaction.

Reply »
lilia wrote
on Monday 31 July, 2017 at 17:31:31 UTC
Is there a lotus designer for MAC OS?

Reply »
P.Mallik Ram wrote
on Wednesday 05 July, 2017 at 12:19:33 UTC
Hi Domino Gurus,

Lotus Domino Server got migrated to new Domino Server by retaining Server and Cert ID. However, the server and cert id passwords are unknown/lost.

The Domino Administrator wants to reconfigure Server with new server and cert id. There are some databases residing inside the server and one significant domino database.

Should the Domino administrator sign underlying databases with new Server ID?

How will it impact our databases? Please help

Reply »
Mike wrote
on Thursday 27 July, 2017 at 20:55:23 UTC
Absolutely, the new server ID must sign the agents. Unfortunately this can have side effects if the agents aren't expecting it.

Yes, you'll eventually get back to normal. But it may take some time or dev effort to get you there.

1- If you're using the same server name, the old signature will fail and the server won't run the agent.
2- Without the old server ID it'll be almost impossible to keep up with the authentication. And then the old server ID will expire, requiring ... re-signing.

The trouble is, all the "unprocessedDocuments" collections are reset when you sign the agent again.

So you may need to change any scheduled / server-triggered agents. They'll need something to the effect of, "ignore all documents prior to [time of signing]."

If you need more technical info, you can also check with the IBM community at the link posted with this reply.

Lutz G wrote
on Wednesday 02 August, 2017 at 14:32:59 UTC
Hi, I had the same problem is an old one created date 1994 and will be valid up to 2019, they thought they do need notes just for 25 years at this time, btu we cannot certify new user.
Any ideas?

Vadim M. wrote
on Tuesday 18 April, 2017 at 20:03:31 UTC
You can try my free apps for IBM (Lotus) Notes/Domino. I work with they many years and think it could be useful for somebody else.

The app Reports Wizard allows you to create reports using data from documents of databases IBM Lotus Notes?

Reply »
Ralph P French wrote
on Wednesday 08 March, 2017 at 16:17:37 UTC
Is it possible to limit a user or set of users from creating replicas from certain databases in Lotus Notus?

Reply »
Mike wrote
on Thursday 20 April, 2017 at 17:31:39 UTC
You can temporarily disable replication, or set replication settings that would send little to nothing down to a local replica.

use groups in the nab and add to the acl wrote
on Monday 01 May, 2017 at 18:49:11 UTC
in the acl, turn off copy or replicate documents

Maribus wrote
on Thursday 11 May, 2017 at 15:03:40 UTC
Yes, databases have permissions about creating replicas.
Disabling ?

Anthony wrote
on Thursday 02 March, 2017 at 15:13:43 UTC
We have 2 domino server v9 in a cluster. We need to ensure that any database created on one server is automatically created on the other server. I managed to achieve this when registering a user through Domino Policies but I would like to achieve the same results for all databases created on the server. Is this possible ?
Thanks in advance.

Reply »
Mike wrote
on Thursday 20 April, 2017 at 17:39:57 UTC
It's possible. But there would be some delay in detecting the database.

The Notes API allows you to scan through every database looking for new databases, then replicate the database to another server.

You'll probably want to exclude say, system databases and such.

I wouldn't advise running such a thing very often, because it'll scan through everything on the server. And that takes resources. Maybe overnight, or every 8 hours, or something like that.

That should be handled with care instead of automation wrote
on Monday 01 May, 2017 at 18:51:11 UTC
try one of the best practices in DDM to check for cluster replicas

Chrisboote wrote
on Monday 10 July, 2017 at 09:17:07 UTC
If you use the catalog, you could set up a 'after documents are created or modified' agent to run with a target of 'all new or modified documents'

Then you can check for each one if a replica exists, and if not, create it

Jon wrote
on Friday 10 February, 2017 at 15:37:33 UTC
Oh how I miss Lotus Notes. My company just moved to Office 365 / Outlook and everyone hates it. It's not a matter of getting used to it - it is just not as efficient and simplified.

Reply »
Mike wrote
on Tuesday 14 February, 2017 at 14:26:33 UTC
I feel the same way. After spending hours searching my email for info, I've given up. Anybody wants me to know something they'd better send it to me when I need to know it.

Rudi Knegt wrote
on Wednesday 01 March, 2017 at 07:17:34 UTC
don't forget the loss of functionality as well.
The MS environment simply can do less, and has less safety. I've not seen any virus outbreak through email on a Notes installation in 25 years. I've seen and heard (first hand) of oh so many on the MS front. Nobody cares when that happens, they simply blame something else.

John wrote
on Wednesday 01 February, 2017 at 15:06:46 UTC
I have auditors who are asking for a report showing any changes to a LotusNotes application during a certain time range. How can this be done

Reply »
steve wrote
on Wednesday 01 February, 2017 at 15:24:59 UTC
If you haven't kept a record of development changes then you won't have this.
If you need to know specifically whether a form etc behaved in a certain way at a certain time, then you would need to restore from backup and manually check the code.

Mike Woolsey wrote
on Thursday 02 February, 2017 at 14:28:45 UTC
If they're asking for the changes to documents, unless the app disables it you can report *which* documents changed in a certain time interval. The $Revisions field lists timedates when a document changed.

It's tougher to tease out *who*. The $UpdatedBy field is a condensed listing of who changed things, in turn. But if there're multiple changes by the same person they may've been uniqued-out.

This feature is enabled, standard, but it can be changed. If you limit the size of these fields, your ability to report from them will be limited.

Unless you're preserving deletions, they are not represented. This is why I normally enable soft deletions for a week or more -- or better yet, build my own deletion scheme.

Further afield: it's possible to track user activity and match that up with actions taken on the database. I normally track that on the *log.nsf*, not on the database itself, because you can program its retrieval from log.nsf.

Notes also offers the ability to handle *versioning*, which is a tremendous ability given the disk space. Your design will need to figure out how to display its versions, and that can complicate your life. But it's a terrific ability to hang onto every change. I wish it were in Xpages.

Patrick Sawyer wrote
on Monday 17 April, 2017 at 21:36:52 UTC
You can add a script to the form that would capture field changes, but this can only be done moving forward not backwards. Let me know if you are interested.

Taija wrote
on Friday 27 January, 2017 at 09:40:29 UTC
I have Notes document application that uses categories and subcategories to organize the documents. I can use "select @all" to select all the docs, I can use "select categories = "category name"" to select one category - but then the subcategories are left out. The command "select categories = "category\subcategory"" doesn't work. What would be the syntax to include also the docs in the subcategories or even to select the docs in them only?

(Lovely site :)

Reply »
Thomas wrote
on Friday 27 January, 2017 at 13:42:10 UTC
You should do something like this:

select categories = "Categories name" | categories = "Categories sub name1" | categories = "Categories sub name 2"

Taija wrote
on Monday 30 January, 2017 at 12:18:27 UTC
select categories = "Top category" | categories = "sub category"
returns only the documents in top category.

Mike Woolsey wrote
on Thursday 02 February, 2017 at 14:30:45 UTC

select categories = "category\\subcategory";

(The backslash is an escape character for @Formula)

Taija wrote
on Monday 13 February, 2017 at 13:24:30 UTC

This did it! :)

Rudi Knegt wrote
on Tuesday 28 February, 2017 at 09:11:04 UTC
you can also use
Select Categories *= "category" : "category\\subcategory1" : "category\\subcategory2" if you need more then one categroy to be selected.
The *= is a list operator in @formula

Mike wrote
on Monday 23 January, 2017 at 21:13:04 UTC
I've been working through SOA and Notes together. What strikes me is all the rigging it takes to set up an environment that'll just kinda run in SOA, while Notes' integrated environment makes the connections pretty straightforward.

With SOA you have to get so much connected & running before writing a line of code. But with Notes, the data you can access is just there to use.

Reply »
Mallik Ram wrote
on Monday 05 December, 2016 at 12:44:26 UTC
We are facing issue with Submit button that works like a charm on Windows OS. The same does not respond on a Macbook Pro.

The Submit button has @Command([FileSave]) in the query save event we have lotus script code.

Does formula language and hide formulas work on a ma?

Reply »
Mike wrote
on Thursday 15 December, 2016 at 14:29:48 UTC
Uh -- it's the server that actually runs the Submit button's formula. All the client browser does is ... issue the Submit.

A lot more would need to be discussed, such as whether your app uses Javascript to issue this button, and whether the MacBook browser is enabled for Javascript, and so on.

With browsers, you get what you pay for. And they're worth every penny.

Mike wrote
on Thursday 22 December, 2016 at 14:24:40 UTC
(I think I responded earlier, but sometimes it doesn't get through the interweb.)

The Submit button code is being run by the server, so it's not specifically the problem. If the browser gets to the point of launching the Submit button, then it's run onserver.

More likely there is some Javascript upstream of your button. Maybe the Web page tries to run the Javascript on-page, and it fails to complete / generates an error on Safari.

There's a lot of browser-specific code out there. Frameworks support more browsers, but they're a learning task unto themselves, and there are a lot of choices.

I'm sorry this leaves you with some digging to find the issue, but I hope it points you in the right direction.

Marilyn wrote
on Friday 25 November, 2016 at 19:47:20 UTC
Hi... I am wondering if there is a way to trap incoming HTML emails and detect presence of a URL; i.e., <a href="">ABC Inc</a>. I can see this raw HTML in the body of the message but when I try to access this programmatically via the NotesRichTextItem Class, it does cannot see the "". The only thing i can search for is the text portion which is "ABC Inc". Please help.

Reply »
Mike wrote
on Thursday 08 December, 2016 at 13:37:39 UTC
I'm not sure of the nature of the issue.

Is the rich text MIME? An HTML MIMEPart can be inspected through some objects in the Domino Object Model. I normally use 'em to create a MIME email, but I'm pretty sure the reverse can also be done.

Sam Sirry wrote
on Tuesday 13 December, 2016 at 02:07:29 UTC
Use the MIMEEntry classes. They should help you achieve what you want. I haven't used them myself so I cannot provide more info....

CJ wrote
on Friday 25 November, 2016 at 13:21:41 UTC
We use a teamroom that we have been provided and I would like to know how the backup / recovery scenario works, and whether it is possible to take a copy of that Teamroom and hold it on a local client as a backup (as well as using a local replica on the same client)

Reply »
Mike wrote
on Thursday 08 December, 2016 at 13:39:56 UTC
Normally a client refuses to hang onto two replicas on one client (or server, btw). So in principle I'd say no, don't do this if they're both replicas.

That said -- it could be possible to launch a Notes client to point to two different data directories if you seriously needed to run both. They wouldn't run at the same time.

Karl wrote
on Monday 12 December, 2016 at 21:07:01 UTC
It depends on your setup of course. But most organizations do have some sort of backup that also gives you an easy restore option. This is a question for your IT department.

With that said, you also have the option to make a local copy of the (any) database as well as a local replica. Although to create a new copy is not an automated process and is needed to be done manually every time you want to make a new backup of the latest information.
To create a new copy - When in the Teamroom db - Click "File/Application/New Copy.." Give the db a name, select a folder on your hard drive to store the db. Done!
Note! This is the way you should copy a database, do NOT just copy the database from within the file system (windows explorer etc.) since that makes the database a local replica instead of a new copy since that gives the database the same replica ID.

Tomas wrote
on Friday 25 November, 2016 at 11:15:35 UTC
I've heard that IBM have now confirmed that the next release of Domino is going to be the last major version of the software to be released. Is this correct?

Reply »
Andreas wrote
on Wednesday 30 November, 2016 at 20:01:56 UTC
IBM is changing his product release publishing from a big main release manner to a more agile and faster way with feature packs. Feature packs includes fixes and new features. On the other hand there are template packs available - if a feature pack offers new functions wich affects a template.

Sam Sirry wrote
on Wednesday 07 December, 2016 at 14:18:06 UTC
There was an announcement that IBM will continue to support Domino & Notes until 2021 at least. But no more details about major releases or otherwise.

Thomas wrote
on Wednesday 08 February, 2017 at 08:53:22 UTC
It's correct - as Windows 10 is the last version of Windows. Or Google Mail, which never had "major" releases/release numbers.

As Andreas wrote: They are changing, how we get new functions in the software - fast feature packs instead of a new major release after 1 to 3 years.

Ivan wrote
on Friday 17 March, 2017 at 22:30:58 UTC
Haha, this I hear since time or so called RNext - Release 6 as far as I remember... dont worry, Notes will live another decade, so many companies still using it.

Tom Hamilton wrote
on Wednesday 09 November, 2016 at 17:05:49 UTC
Hi all - I've been asked to put an automation together to save attachments from our email system. I'm looking for resources for programming Lotus Notes 8.5.3
Scenario: several hundred (>500) emails arrive each month via a secure process (Accellion). I need to detect the arrival, extract the attached files which can be zip or xls/csv format.
I appreciate any direction or resources - thank you

Reply »
Mike Woolsey wrote
on Thursday 10 November, 2016 at 18:25:49 UTC
The Domino Object Model is where you want to go.

There are useful ways to retrieve documents that arrive in an inbox: a collection of unprocessed docs can be handed to either LotusScript (read: BASIC) or Java using the (Notes)Database.UnprocessedDocuments method. Once there, you can process document by document and get a list of (Notes)Document.EmbeddedObjects.

This is the recommended method -- if the attachments appear in the email as embedded objects ("above the horizontal line").

It's possible your email does not embed the attachments. In that case the strategy changes, and I would recommend you stick with LotusScript to try this next attempt. LotusScript can hand you the attachment names when you ask for the value of each "$File" item (e.g., using NotesItem.GetValues(0) ). From there you can use NotesDocument.GetAttachment("filename") and extract each file. The docs lead me to believe this is not available in Java.

If you need help scanning through a folder or a database the Help documentation has a short tutorial on how most LotusScript agents scan views, search collections, & etc. It's short, it's very practical, and highly recommended.

Inotes new them wrote
on Monday 07 November, 2016 at 07:54:03 UTC

Is there any other template for inotes to use or to buy from a third party. I am using Domino 9.

Reply »
Mike Woolsey wrote
on Thursday 10 November, 2016 at 18:32:33 UTC
I've seen other templates for Notes, but I haven't looked for iNotes in particular.

I've also seen descriptions on how to customize iNotes. Some are in

Karl wrote
on Monday 12 December, 2016 at 21:12:06 UTC
This might not be what you are asking for and you only want iNotes specific info, but there is a new Webmail theme for Notes Domino called Verse. Verse is available today for cloud users but it's in late beta stage today for on-prem installations and will be released soon.

Frank wrote
on Monday 07 November, 2016 at 02:16:16 UTC
Is there a Lotus Notes API to determine if a document contains an embedded object? For example, an email document where the user used copy and paste to paste a spreadsheet. This typically shows as a gif file in the Louts Notes document.

Reply »
Tom wrote
on Thursday 10 November, 2016 at 15:29:34 UTC
Yes there is. In the Domino DLL, object NotesDocument Boolean property HasEmbedded.

'Check if the document has an attachment or not.
If oDoc.HasEmbedded = True Then

Set vaItem = oNextDoc.GetFirstItem("Body")
If vaItem.Type = RICHTEXT Then

For Each vaAttachment In vaItem.EmbeddedObjects
If vaAttachment.Type = EMBED_ATTACHMENT Then

'Save the attached file into the new folder.
Debug.Print CStr(vaAttachment.Name)
Dim sFile As String
sFile = CStr(vaAttachment.Name)
'If Dir(sFile) = 0 Then ' Check for existing file
vaAttachment.ExtractFile csPath & vaAttachment.Name
' Dim tdStamp As String
' tdStamp = Format(Now(), "yyyymmdd_hhnnss_")
' vaAttachment.ExtractFile csPath & tdStamp & vaAttachment.Name
'End If
Debug.Print "Extracting " & vaAttachment.Name & " to " & csPath
'Set the e-mail object which will be deleted.
'Set oRemoveDoc = oDoc
End If
Next vaAttachment

End If
End If

Ian Pal wrote
on Thursday 03 November, 2016 at 00:25:36 UTC


- Creating Private View inside notes designer
- Action Click
- OLE Classes not installed locally on the machine but are installed on the server machine

Question 1
I am wondering if anyone knows how to reference OLE classes via view inside an action i can see the classes in the reference tab under OLE Classes that i want to use problem is i cant seem to reference them? Eg Acro and HTML classes
using create object i assume?

Question 2.
Could the create object not work because i do not have the OLE class libraries installed locally and if i do need them locally then how would one make it link to the notes designer?

Reply »
Mike Woolsey wrote
on Thursday 03 November, 2016 at 22:07:15 UTC
CreateObject() is normally what I use. Then you don't have compile-time success that later crashes when you're on a machine that doesn't have the classes installed, you can check for runtime errors or null handles.

I always used locally-available COM objects, so if that's your situation, yes, that could be an issue.

I remember there was once DCOM ... I don't know, I never got it to work very well.

Tim wrote
on Friday 28 October, 2016 at 21:47:31 UTC
Whats the easiest way to fix a corrupt $inbox?

Reply »
Mike Woolsey wrote
on Thursday 03 November, 2016 at 13:38:23 UTC
It depends on the corruption, but the easiest, first attempt is to open it & press Shift-F9. This'll rebuild the collection if the collection is corrupted.

If the folder design itself is corrupted, it's more involved. Make a backup copy of your current DB, no docs, to a template (when copying, give the empty copy a .ntf extension not a .nsf). Go back to the DB itself. Create a new folder & drag out as much of the contents as you can. Then design the folder, delete it, and replace design from the standard template (not your backup) back into the DB to restore the folder.

Sam Sirry wrote
on Friday 28 October, 2016 at 18:13:40 UTC
I love Lotus Notes, and I love to use the "Lotus" brand name despite IBM's attempts to wipe it out.

Notes is my personal favorite database storage system. My personal tools & utilities are built with Notes. Seriously, I cannot imagine using any other system with the same versatility.

One thing that makes me sad about Notes is that it is made in a country where the law there considers me a bad inhabitant of the planet just because I carry a passport from a certain country, and I am no longer allowed to purchase licenses, but still I know that the people of Lotus who originally created Notes did it for the good of the whole humanity.

Notes will last forever.

Reply »
Sam Sirry wrote
on Tuesday 18 October, 2016 at 08:22:18 UTC
I can't seem to find statistics showing the operating systems on which Domino Servers are installed.
I mean, the general IBM customer base, how many use Windows, Linux, other? Any idea?
I'm only looking for data regarding the Domino server.


Reply »
Mike Woolsey wrote
on Monday 07 November, 2016 at 15:26:35 UTC
I don't know that IBM produces stats. From the significance of the bugs & speed they're found, I'd say Windows is overwhelmingly primary, then Linux, then one of IBM's Unix series (mq? i? not sure of the terminology). Just based on the sophistication of the issues I've heard under discussion.

Mark Crosby wrote
on Friday 14 October, 2016 at 21:24:31 UTC
For some reason I can't reply to "Create lotus notes email but don't send" dated 25-SEP-2016. Perhaps that "name" is too long.

Anyway, if Notes is you default email client, but create a link with a URL like this:

You need to make the replace spaces and other special characters.

Reply »
Edward Perrier wrote
on Friday 14 October, 2016 at 21:21:39 UTC

I need alittle help. I have Lotus Smartsuite 9.1 and I need to convert it to excel or to sharepoint.

Please contact me at

Reply »
Mike Woolsey wrote
on Monday 03 October, 2016 at 19:53:34 UTC
Opening Mail in Notes (Fradiocey) --

There's a variety of ways of opening a mail doc in Notes. Probably the most straightforward is to launch a "mailto:" link. This should allow you to set a subject line -- I don't remember if it's enhanced to also let you specify some body text, but I do remember it'll handle the subject.

If you really want to enhance it further, yes, Excel VBA will happily load Notes objects in COM. However, this requires more extensive coding than "Hey, pop up an email."

The Help documentation has a section, "Using OLE", that describes how to get the main objects. You'll actually need both NotesUIWorkspace (to display a doc in Notes) & NotesSession (to retrieve the mail DB path).

I know in earlier versions it was also possible to simply hand Notes an @Command; I don't see that in the documentation any more, but it may still work.

Reply »
Sam Sirry wrote
on Thursday 27 October, 2016 at 22:51:06 UTC
@Commands cannot be invoked thru VBA, but the simple answer still involves a bit of coding. Here are the general steps (for VBA):
1) Get a handle to the notes session. This involves authenticating with an ID.
2) Get a handle to the mail database, like this:
Dim maildb As New NotesDatabase("", "")
Call maildb.OpenMail
3) Create a new document object in the mail database. Set the form as "Memo" and any other fields as desired. You don't need to save the document.
4) Open the document using the notesuiworkspace. I didn't check, but this step is probably not be possible from VBA; in this case you might want to create your own interface for entering data in the fields...

Reportgunner wrote
on Monday 06 February, 2017 at 15:17:12 UTC
Sub mailsender(EmailRecipient as String, EmailSubject as String, AttachmentPath as Strin)

Dim Maildb As Object
Dim MailDoc As Object
Dim Body As Object
Dim Session As Object

'Start a session to notes
Set Session = CreateObject("Lotus.NotesSession")
'This line prompts for password of current ID noted in Notes.INI
'Call Session.Initialize
'or use below to supply password of the current ID
Call Session.Initialize("Pernikopotulnik9")
'Open the mail database in notes
Set Maildb = Session.GETDATABASE("", "C:/Notes/Data/archive\a_CZZ6197A.nsf")
If Not Maildb.IsOpen = True Then
Call Maildb.Open
End If
'Create the mail document
Call MailDoc.ReplaceItemValue("Form", "Memo")
'Set the recipient
Call MailDoc.ReplaceItemValue("SendTo", EmailRecipient)
'Set subject
Call MailDoc.ReplaceItemValue("Subject", EmailSubject)
'Create and set the Body content
Call Body.APPENDTEXT("Body text here")
'Example to create an attachment (optional)
Call Body.EMBEDOBJECT(1454, "", AttachmentPath, "Attachment")
'Example to save the message (optional)
'Send the document
'Gets the mail to appear in the Sent items folder
Call MailDoc.ReplaceItemValue("PostedDate", Now())
Call MailDoc.SEND(False)
'Clean Up
Set Maildb = Nothing
Set MailDoc = Nothing
Set Body = Nothing
Set Session = Nothing

End Sub

Neill wrote
on Sunday 02 October, 2016 at 20:39:07 UTC
Hi -
I'm creating a system in c# using pmengal/MailSystem.NET to download emails from a domino server using IMAP. I'd prefer to not tie the system to LotusNotes (LN) too much so that is why I'm favouring IMAP.

So my system is going to download new emails via IMAP, but then I'd like a way for the user to click on a link which will take them directly back to their email within the LN client. I've debugged in Visual Studio to see if I can extract the key components that will allow me to build up the following url. This is the format of the URL which LN creates when you drag an email to your desktop:

I can think of only one way of doing this and that is to create an pre-delivery agent that adds the link above to all emails that are received? Then my program then extracts that from the email. I'm reluctant to use the Domino SDK as there are few resources out there on it.

Any help would be appreciated.

Reply »
Mike Woolsey wrote
on Thursday 27 October, 2016 at 16:23:09 UTC
Um, there's quite a bit of resources on the Domino SDK if you need it.

I'm not sure exactly what you're looking for. Once you're limited to IMAP, I'm not aware of something in IMAP that can hand you back identifying information or even other metadata about the document. But that's IMAP, I would think. Is there such a thing? What can IMAP give you?

That seems to be the limitation. As for the URL format, you have more options, but if you can't get more metadata through the IMAP piping, I'm not sure it'll help.

If you can get the Document's UNID and the location of the database -- or just the server/DBID of the database, either one -- the view itself is optional -- it could simply be "0".

So for instance, you could also have a URL that opens the email like this:


TimC wrote
on Friday 30 September, 2016 at 18:38:28 UTC
Has anyone used Powershell or another scripting language to take a text file with group names and create the groups in the NAB? If so please share the code!


Reply »
Mark Crosby wrote
on Tuesday 04 October, 2016 at 18:03:43 UTC
Not exactly what you asked for, but a possible solution could be to create a .CSV file with the fields you want to import to the Group document. Names would be separated by semi-colons. Create a .COL file to define the mapping of .CSV values to Group form fields. Import the .CSV file as Tabular Text and specify the .COL file in the import dialog box and you're done!

akil wrote
on Friday 30 September, 2016 at 10:26:38 UTC
is there any way to create dynamic fields and bind it using xpage lotus notes

Reply »
PetiAti wrote
on Wednesday 28 September, 2016 at 11:26:46 UTC
I'm using a LotusScript to export data from Notes to Excel. When I tried it on Mac it doesn't work because it cannot create the Excel object. How can I export data on Mac?

Reply »
Mike Woolsey wrote
on Thursday 29 September, 2016 at 14:49:50 UTC
I can't really tell you what Apple's letting applications do nowadays, because I just don't get much call for it. I've noticed a number of people having problems intercommunicating on a Mac. I'm inclined to view the issue in reverse.

If there's such a thing on Mac maybe it can be accomplished in reverse from what you're expecting Notes to do. Or maybe, learning what Excel can do with Notes objects, you might be able to apply the results back into LotusScript BASIC.

What facilities does Excel for Mac have to communicate? I too k a quick look around & I couldn't find a nice, quick way for Excel to talk to the Notes API. Is there one? Maybe. I just can't find one.

Is there an interoperation protocol Excel can use to call Notes objects? VBA can do this on Windows. I've actually done it over COM. And LotusScript being a "super-VB", it does this too.

Joe Brender wrote
on Friday 14 October, 2016 at 14:13:14 UTC
I have a similar experience doing this on an iSeries server, where you can't use Excel OLE. The answer is Java POI. It allows you to create, export, import and modify excel sheets without having excel installed.

Create lotus notes email but don't send wrote
on Sunday 25 September, 2016 at 14:46:08 UTC
I'm really stumped with Lotus Notes and wondering if anyone has code that can be run from Excel or Word using VBA. I just want to create a blank email and populate the subject and body text and that's it. I don't want to send it but I need it to display on the screen so the user can complete it.

Reply »
Fradiocey wrote
on Friday 23 September, 2016 at 04:27:50 UTC
Hi, is it possible to get client mobile operating system & version information from lotus script? I tried using @Platform but no luck. Thanks

Reply »
Khader Quraishi wrote
on Tuesday 04 October, 2016 at 17:07:12 UTC
Please try @browserinfo("Platform") and see.

sidney wrote
on Thursday 22 September, 2016 at 15:54:12 UTC
Can someone tell me if its possible to vreate a user account and automaticly add db's to his or her workspace? im new to Notes but it is really time consuming to add 30 db's for each new user. and if so, is it also possible to create local replicas automaticly ? im looking for something like a user template. please let me know

Reply »
ilovelotusnotes wrote
on Thursday 22 September, 2016 at 16:07:34 UTC
yes that's possible. a number of ways to do this, but you'll need a Notes developer to get this right for you. you may also want to consider a single database used as an entry point to all those apps - like an intranet home page. I'm not sure of any specific templates for this - but you could create something that looks awesome and is specific to each user...

Sidney wrote
on Thursday 22 September, 2016 at 16:29:32 UTC
The rights some will give me and we aklready have something like a homepage with some links but i want to use the workspace for this, is there some documentation regarding this ?

Joe wrote
on Thursday 22 September, 2016 at 16:53:41 UTC
Try using a "Setup" policy. It lets you add databases to bookmarks automatically. If you google around the policy stuff, you can figure out how to do replication as well.

Mark Crosby wrote
on Wednesday 28 September, 2016 at 22:08:15 UTC
You can also use Policies to do this. Check out the Desktop Settings policy documentation

Lance Manion wrote
on Thursday 15 September, 2016 at 01:18:49 UTC
I have some very old Lotus Notes email files that I'd like to access, but I can't seem to find a solution. I don't know what Notes version they were created in, but the files are well over 12 years old.

All I want to do is load a version of Lotus Notes on my personal PC so I can read those files. I don't need database functionality. I don't need to send/receive email. I don't need any networking capabilities. Just the ability to open and read old lotus notes email files. I can't seem to find any solution. Do you have any idea how I can accomplish this?


Reply »
ilovelotusnotes wrote
on Thursday 22 September, 2016 at 16:08:45 UTC
You should be able to open the oldest mailbox in the latest version of Lotus Notes as far as I am aware (although not tested this to be honest).

Joe Brender wrote
on Tuesday 27 September, 2016 at 17:44:46 UTC
Notes 9.0 is backwards compatible all the way back(they all are), so versioning is never a problem. Don't worry about "old files" not opening in a new client.

I think the biggest problem would be having an id file that has access to those 12 year old files. If they are your mail files, it shouldn't be a problem. Install Notes and use your id file to login to notes then open the files. If it was your work mail from Company A, and your work email from Company B, and the id expired on both, then you're not going to get those files open without a certifier ID.

Mark Crosby wrote
on Thursday 29 September, 2016 at 16:41:22 UTC
I think you "just" need to get a copy of the Lotus (IBM) Notes client installed on a PC and open the mail files locally. You can get the Designer client for free now, but the end user client isn't free. Notes has been pretty good about backwards compatibility, so any Notes client created since the one that created the mail files was released should work fine.

What Joe B. said is true, but only if the database was encrypted using the old ID. If you copied the mail files from a server at the OS level, then chances are they aren't encrypted. If they were local replicas on someone's PC, then they very well could be.

Joel wrote
on Friday 30 September, 2016 at 05:05:02 UTC
One issue I think you're likely to run into is encryption. Notes e-mail files typically have encryption keys in them to prevent exactly what you're trying to do (someone downloading the file and then opening it without having a Notes Id with access to the file.

If this is an issue, you'll probably need the certifier Id used to originally sign the e-mail database file in question. All of the administrative functions to resolve the problem of not having access to an old file require the certifier id (even to re-sign the database with another certifier) for security reasons (so someone can't simply copy the database to their local hard drive and then open it with no security check).

Teh Hong wrote
on Wednesday 14 September, 2016 at 11:16:28 UTC
I need some help and advice. We have a script that open an Excel file in Windows with its path stated e.g C:\excel.xls but this is not working for Mac. How can I open an excel file; THexcel.xls say in "\User\TH\" in Mac? Thank you.

Reply »
Matt Fitzner wrote
on Thursday 08 September, 2016 at 19:43:39 UTC
congrats to your site!

Do you know any Voip plugin solution that can use embedded Sametime Client and can be connected to Asterisk? Like ilink - but ilink does not Support or implement with Asterisk..

Thanks for joining ypur knowledge.

Reply »
Victor wrote
on Thursday 08 September, 2016 at 04:34:00 UTC
Can't find information regarding mail enabled workflow applications in lotus notes and sending to exchange 2013. There must be some setting? or would I need to modify my lotus script code? for doc.send or @MailSend functions?

Reply »
Mark Crosby wrote
on Thursday 29 September, 2016 at 16:56:17 UTC
Notes applications will send emails depending on how the Notes client is configured for mail. Typically the client would be configured to have a mail going through a Domino server. The Domino server can be configured to connect internally to an Exchange server. However if there is not Domino server involved, Notes clients can be configured to use non-Domino servers for POP3, IMAP and SMTP. These connections are configured in the Advanced settings views of the local Name & Address Book (names.nsf) on the Notes client

Neill wrote
on Wednesday 07 September, 2016 at 14:03:19 UTC
I'm looking to find out whether it is possible to create a To Do item using the SDK preferably in C#. Or even to create an agent to convert an email into a ToDo item automatically if the subject contains particular characters/codes.

Reply »
Joel wrote
on Friday 30 September, 2016 at 05:11:27 UTC
You can do it with COM as the example shows (it creates a calendar entry, but the process is the same). If you have code currently to create an e-mail, you're just going to be changing the Form field and a few others (easiest thing to do is open the To Do field in a calendar using the Domino Designer and check the fields that exist there. Some will be optional, but especially look over the hidden fields and understand what they do - which ones should be set for your ToDo item to work properly).

Neill wrote
on Sunday 02 October, 2016 at 20:04:28 UTC
Thanks Joel

Rusty wrote
on Thursday 01 September, 2016 at 00:05:13 UTC
Is there a way to copy a custom view of a locally replicated database to another machine? We do not use any communication features in Lotus, only database management.

I have a killer custom view that others I work with would like to have, but cannot build it on their machines (field employees spread over the nation).

Can it be done?

Reply »
Steven Elwell wrote
on Wednesday 28 September, 2016 at 17:17:02 UTC
Depends on if the view is stored in the database or in your desktop.dsk

Mark Crosby wrote
on Thursday 29 September, 2016 at 17:04:58 UTC
When you said you "do not use any communication features in Lotus", does that include Replication?
Given the limited information provided I am going to speculate that you have an application that is being used by employees around the nation and that the data in the application is shared via replication.
You can (with the appropriate ACL rights) use the Domino Designer client to copy the view from your local db and paste it as a shared view in the server's replica copy. The replication task will distribute it for you, assuming the replica settings send design changes as well as data changes.

Joel wrote
on Friday 30 September, 2016 at 05:23:01 UTC
If the view is not a private view (if you created or can create it as a global view), you can add it to the server version of the database (or the template that database uses, and update the database from the template). The users will have to replicate from the server (I presume they're already doing this/know how to replicate data from the server?) to pick up the design change.

Another option is that you can create a database with a Page and a button that uses LotusScript to perform a design refresh on the other database. You would send that database to each user via E-mail. This method involves a bit of programming however, and is not trivial.

R.X.Britto wrote
on Wednesday 17 August, 2016 at 14:13:19 UTC
Is there a way to search this site?


Reply »
Rusty wrote
on Thursday 01 September, 2016 at 00:02:57 UTC
I always use Ctrl+F and use the browser's search tool.

Neill wrote
on Wednesday 07 September, 2016 at 14:06:42 UTC
try.. putting this in a google search and it will search this website...

Domino run Wordpress

AndrewK wrote
on Thursday 28 July, 2016 at 00:04:30 UTC
I have Excel VBA that creates and email in Lotus Notes from data in the spreadsheets, graphics and text and allows the user to view it before they send it.

I need a way of sending an email from Excel 2016 to Lotus Notes on a Mac. I am using COM on Windows.

I have seen Lotus Notes command line commands to open a new email but I can't populate the contents of the email.

I've looked at command line, AppleScript and LotusScript.

Any ideas please ?


Reply »
Lance Z. wrote
on Friday 12 August, 2016 at 14:25:29 UTC
Nubia Dear wrote
on Friday 22 July, 2016 at 15:38:50 UTC
Very nice and informative article here. Cool to read such a well-considered article! BTW, if anyone needs to merge PDF/PNG files online, I found a service here "".

Reply »
RobertMorgan wrote
on Wednesday 06 July, 2016 at 16:05:47 UTC
Is there any way, application, or plug in available to view saved .msg files in Notes?

Reply »
shane wrote
on Thursday 28 July, 2016 at 04:04:56 UTC
notepad, notepad++, import them in as txt?

BillyG wrote
on Wednesday 29 June, 2016 at 17:32:51 UTC
What happens to the Notes client trial after the 90-day period? Does it stop working or does it just nag?
If I'm trial-ing something out in the field, I don't want it to stop working in the middle of something important before I can get P.O. approved

Reply »
Mike Woolsey wrote
on Wednesday 13 July, 2016 at 14:34:45 UTC
It won't stop working.

Tom Hillebrand wrote
on Thursday 25 August, 2016 at 15:00:00 UTC
It's won't nag you either. It will perform the same.

Sozos wrote
on Sunday 26 June, 2016 at 10:07:17 UTC
Hi All

I have a very annoying issue with Lotus Notes private views. The selection formula I am using is @name([CN];staffName) = @name([CN];'username). So basically restrict the view to display only the specific user's document. However, for some reason every now and again a user will inform me that he cannot see his document. if I save and close his document the document appears in his view. Any advise?

Reply »
Mike Woolsey wrote
on Wednesday 13 July, 2016 at 14:33:12 UTC
Unfortunately, this could be due to the view refresh settings.

I say that's unfortunate because it's a private view. So it's pretty unpleasant to go through the process of re-creating all the private views for everyone everywhere.

I've taken to using single-category views. There's a @SetViewInfo() function that lets you restrict a particular view to one category. They y'just categorize by @Name([CN]; @UserName).

Still, there are drawbacks: the "alternate sorting" features don't work.

Also, one tradeoff is performance, but it's not a direct tradeoff. If your database is huge, @SetViewInfo will block everything while it tries to open the view the way you want the user to see it. OTOH, each activity keeps the view up to date for everyone. So it can be a trade to your advantage.

Akil wrote
on Tuesday 21 June, 2016 at 06:41:53 UTC
How dow pull attachments from SQL server to lotus notes and create a document with attachments

Reply »
Mike Woolsey wrote
on Wednesday 22 June, 2016 at 14:05:29 UTC
It's really a question for Microsoft side.

With Notes there's a NotesEmbeddedObject class that'll let you attach files into a document.

Mike Woolsey wrote
on Wednesday 29 June, 2016 at 14:05:01 UTC
There's an "EmbedObject" call for in the NotesRichTextItem class, and attachments are supported in a NotesEmbeddedObject class.

I think the issue is more, how do you pull the document out of Microsoft SQL Server. Check with Microsoft on that.

Mike Woolsey wrote
on Tuesday 12 July, 2016 at 14:05:57 UTC
Hm, maybe my original response got lost in the Web ether.

The NotesRichTextItem object has a nice "AttachFile" method, so ... not a problem for Lotus Notes.

I believe SQL Server stores things as binary objects, which means you have to convert anything stored there into an attachment & save it.

Polymorph Ltd wrote
on Wednesday 15 June, 2016 at 12:00:57 UTC
Here's a solution to a long standing issue with the Lotus Notes client and high DPI displays (e.g Microsoft Surface).
This should hopefully get your Notes apps back to looking great again, it has worked a treat here!

Reply »
Monty wrote
on Friday 21 July, 2017 at 02:23:00 UTC
Hi there,
This works well, but crucially makes all tiles in my workspace huge. Not real practical if you have a significant number.
Have you found anything to keep workspace scaled correctly?

Rohit Singh wrote
on Friday 10 June, 2016 at 20:37:39 UTC
Hi I have a table in a lotus notes document containing columns Item no., Item Description, Item Quantity.

I have to show this document 5 times in a view of the table has 5 rows with different item no.

And each item row should have the corresponding values from the column.

How do I Acheive this last option of showing only the corresponding value of each item. I am able to show 5 rows in the view if there are 5 rows in the table.

Please help with an example!!

Reply »
Mike Woolsey wrote
on Thursday 16 June, 2016 at 00:25:07 UTC
Try this:
Add a column with your Item Description, just to the right of your Item Number column.

Now **don't** sort or categorize the column.

Check the setting "show multiple values on separate rows".

Again, **don't** sort or categorize the column.

Try this on the simplest view, selecting only the docs you want to display, and with only this set of columns, first.

There are distinct limitations on this kind of view, so don't expect it to work with every other feature. Alternate sorts and sorted columns "in between" can cause tangles. So keep the view pretty straightforward.

Terry Comeau wrote
on Wednesday 08 June, 2016 at 19:38:13 UTC
We us laptops in the field to document claims using apps developed in IBM Notes. The data and forms are replicated back and forth between the server and the laptops. The adjustors can create a summary document to print off and get the client to sign. We'd like to get away from the printers in the field.

How can we create a summary report and get a signature from the client onto that document in the field? And back to the server.

Where would I start?

Reply »
shane wrote
on Thursday 28 July, 2016 at 04:08:10 UTC
COM / OLE to a MSPaint image, using a touch screen would allow them to draw their signature on the screen and it can be saved. Documents Library Database would let you do that.

Mark Crosby wrote
on Thursday 29 September, 2016 at 18:49:03 UTC
I worked with a signature pad from a company called Topaz 15 years ago. An extra piece of hardware is probably not what you want, but they (or someone else) might have a software 'signature pad' that could capture the signature image.
The image of the signature will be unique since no one signs *exactly* the same way each time. This unique value is used in conjunction with the values in the fields you want to secure to create an encrypted signature. Changing any of the values invalidates the signature.
Wow! They still have the code sample I provided to them 16 years ago. (
Looks like they have some software options, I'll include the link below.

DF wrote
on Tuesday 07 June, 2016 at 18:53:43 UTC
Hello, everyone.
Thank you all for responding to a previous question that I had, I greatly appreciate the help.
I do have another strange situation that I could use some assistance with.
One of the environments that I manage has a monitoring server that has an event generator set up that checks the connection to all of the servers (and to the DDM.nsf replica on each of the servers) in the network every 3 minutes. If that connection attempt times out, the event generator is configured to send out an alert email. I should mention that the servers are in different domains, but the monitoring server has valid connection documents to all of them.

The problem that I am noticing is that when I bring down one of the servers, the event generator does not send out the alert email. By watching the JConsole on the monitoring server, I can see that the event generator checks and notices the failed connection, but it doesn't follow up by sending out the message like it should.

Now, here is where it gets weird. If I forcibly restart the event monitor task on the monitoring server, it then sends out that alert about the failed connection....and this could be hours from when the actual event actually happened. It is as if the event generator and/or the event handler message is somehow getting stuck, and only when I restart the event monitor task, does it then release the message that it was supposed to send out when the event first happened.

Now, for some reason, this doesn't happen with every server that the generator is set up to watch. The event generator number is the same, we just added every server that it needs to check to that one event generator (it's only about 16 servers). And, the events4 and DDM databases are all replicas across the environment (which are all properly replicating), so I cannot figure out what is causing this message lockup to happen.

The other weird issue that I have noticed (and I'm not sure if it is related to the event monitor issue or not) is that the monitoring server is constantly showing a message in the logs that states "Suppression interval = 0", and it seems to throw 3-4 of them in a row right when it should be sending out one of those event notifications. I cannot find anything anywhere that references this specific message, and it does not point to any specific ini setting that is set up on the server. I say this because none of the settings on the monitoring server have anything to do with any type of suppression interval.

If anyone has any insights to this problem, or the console message, please let me know. I have tried contacting IBM's support about this, but that was a lesson in futility.

Thank you all very much.

Reply »
Mike Woolsey wrote
on Thursday 09 June, 2016 at 14:55:21 UTC
Well, to get more information, I believe there're two Notes.INI settings that'll log volumes of data about events:


You may have to sort through what it thinks is happening, and I'm not sure what other events are in progress so it could be a lot of info.

PEIDER wrote
on Tuesday 14 June, 2016 at 20:38:17 UTC
Hello DF,

maybe this info can help you ....
It may be possible that here are to much Messages at the same time ...

Angelia wrote
on Friday 03 June, 2016 at 02:30:42 UTC
Microsoft Office Library template (StdR7DocLibMS) only supports old version of Microsoft office. Is there any way to get a template for Office 2010 and above

Reply »
Mike C wrote
on Thursday 02 June, 2016 at 16:53:37 UTC
Anyone know how to get acrobat working with Notes 9. The actions to convert message to PDF are no longer available.

Reply »
Mike Woolsey wrote
on Thursday 09 June, 2016 at 13:43:46 UTC
I remember this from a while back, maybe it'd help:

Brett wrote
on Tuesday 31 May, 2016 at 16:45:25 UTC
Hello, we use Domino to review documents here. We are experiencing an issue with Word 2016 where documents do not open properly (Domino works to the point where the file is downloaded, but Word 16 then says "Invalid Document ID")

Do you have any advice?

Reply »
Mike Woolsey wrote
on Thursday 09 June, 2016 at 13:42:10 UTC
There's an outside chance you may need to add the following registry entry:


If it's specific to Microsoft Word 2016 and not earlier versions, it'd appear that it's ... specific to Microsoft Word 2016 and not Lotus Notes. You didn't change Lotus Notes, you changed Microsoft Word, and that introduced the issue.

Aside, I'm sure Microsoft will weigh in as doing something new & exciting so as to break this. Thousands of .rtf files were broken when they introduced Word 2010, and I've yet to see any substantial action to recover them. I still have Word 97 handy to read documents out of our archive.

Good luck!

MJ wrote
on Thursday 26 May, 2016 at 19:41:35 UTC
Help, please! I need a Lotus Notes expert. We recently launched a new team database in Lotus Notes. We're noticing some senders (specifically, other Lotus Notes team database IDs) email's are coming in flagged normal priority. The users of those other databases insist they are not flagging their emails to us. How do we remove the flag on specific users so future emails do not automatically get flagged?

Reply »
Bikswan wrote
on Tuesday 24 May, 2016 at 00:25:32 UTC
Hi, do you know if there is any third pary .Net API available to extract emails & attachments from Lotus notes database? is it required to have lotus notes installed on PC to use Lotus Notes C++ API.

Reply »
Polymorph Ltd wrote
on Tuesday 24 May, 2016 at 09:51:53 UTC
Absolutely, for pure email+attachments you have a number of non C++ / client choices (assuming you have a Domino server):

* Use a .Net IMAP / POP3 library
* Use REST ( )
* Write your own domino SOAP web service & call from .Net

Ivan wrote
on Wednesday 11 May, 2016 at 20:06:38 UTC
I miss Domino and Notes client so much! After 12 years running numerous business applications in Notes I am trying to deploy similar business apps on Drupal and other MS platforms and it is incredible pain in the ass!!! What took hours in Domino takes days and weeks in php/Drupal.

Reply »
Sue H wrote
on Wednesday 06 April, 2016 at 04:42:08 UTC
We use Notes/FX in many of our databases and will soon be upgrading to Office 2016. When I tested field exchange with Excel 2016 it doesn't appear to work. Is it no longer supported or is there a work-around?

Reply »
Polymorph Ltd wrote
on Wednesday 08 June, 2016 at 14:07:51 UTC
Hi Sue,
We tried here too and found very much the same. One thing to check might be if you're using a 64 bit version of Office as it may need to be 32 bit for it to work with Notes.
In nearly all cases we have replaced NotesFX with LotusScript/OLE agents to update/create Excel spreadsheets (and this works fine in Office 2016 as we use it daily).
Hope that's of some help!

Jaime Robertson wrote
on Tuesday 29 March, 2016 at 03:53:13 UTC
Interesting Blog! I use Follow Up flags extensively, with context tags in the Action field. In the standard Follow Up view, I can not sort or filter the Action field. Is there anyway to do this or to create a custom view specific to the Action tag (i.e. @Ryan 1:1). Thank you.

Reply »
AC wrote
on Wednesday 09 March, 2016 at 17:23:13 UTC
Hi there, are there any "free" tools out there to allow one to report on existing users versus numbers of mailboxes and/or unused mailboxes, etc?

Reply »
Ptr wrote
on Monday 22 February, 2016 at 20:11:26 UTC
How can I get a trial of Lotus Notes 8.5.3? I have registered and ID on IBM site but its just impossible to find a link to a sensible download. Any clues please?

Reply »
Mike Woolsey wrote
on Wednesday 24 February, 2016 at 14:59:23 UTC
I don't know if 8.5.3 is still available, but I had another thought. Are you looking at it for email, or for application development?

I believe it's Notes 9 that shows up as an evaluation, today:

When I downloaded Domino Designer 9, it included a copy of Notes 9.

I don't remember whether the email template is included with Domino Designer. If it is, you could get an initial look at email as well. It's hard to get a complete picture, but you get a lot more than, say, Sharepoint without the server (...!!).

Now, granted, you don't have an ID license for Notes 9, that comes at a cost. And no, it's not a server. However, you can see a whole lot about Notes and really, Domino applications' interface to Notes, from Domino Designer.

Irene wrote
on Friday 19 February, 2016 at 10:32:47 UTC
I am so glad to hear someone loves Lotus Notes. If managed properly it is more stable and great to use.

Reply »
Thomas wrote
on Tuesday 20 September, 2016 at 08:59:19 UTC
I fully agree. I love Lotus Notes. It's very cool because its open. Even if almost everything is included, those few bits one might miss, can be added easily.

Too sad, that IBM does such a weak marketing for it.

older posts >

Advertise Here!

Hey – if you like it, add a comment – no need to register!

Want to get in touch? Send us an Email.

Show your support on your sleeve website.

keep me updated



Submit Button

Ed Brill
Bleed Yellow
Planet Lotus
Mary Beth Raven