Email HTML Hotspot from Lotus Notes - Initialize Help Needed

Found this thread yesterday, and it solves beautifully what I am trying to do in email - send clickable custom hotspot link via Lotus Notes.

http://www.excelforum.com/excel-prog...e-hotspot.html

As is, it works so well in my test. Where I am needing help is on the initialize/get database part. I modified for my Notes nsf file, but this will ultimately be used by several others and I am needing to set DB as s.CurrentDatabase, but am getting not implented error when I revise per below. Any ideas as to how to modify to current database vs hard coding mail nsf name(s)? That way I won't need to modify or add nsf names/paths depending on OS and users. Thank you!

Original:

Please Login or Register  to view this content.

Revised:

Please Login or Register  to view this content.

Sorry, should have posted entire code from link for convenience. It is New NotesSession. Entire posted below, hope this helps, thank you.

Please Login or Register  to view this content.

I am not sure how Hotspot is the help needed. I think you are asking for how to get the current user's database.

Here are two examples.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you, I have not seen the first method and will keep that on hand. Have used the 2nd method but was unable to find a way to make it send a clickable hotspot from Notes that is a link to a network file. The method from the link I posted works perfectly for that part, which in this case, is the most important need. However, solving one problem, getting clickable hotspot, led to new problem, of how to get current database for nsf. I tried several ways to incorporate your 2nd method, but no luck, I don't know how to combine the best of the 2 methods (clickable hotspot & current database). Hope this helps, thank you.