Hello, one of my users wanted to include hyperlinks to some Notes documents in an Excel sheet. Is there a way to do so?
Subject: Document link in Excel sheet
Yes,you can do this by the foolowing steps.
1.In Notes dcoument,from the Menu choose Edit—>Copy as Link—>Document Link.
2.Goto the Excel sheet,from the Menu choose Edit—>Paste Special—>select Paste Link.(Display as Icon is optional for you).
3.Click Ok.
Cheers,
Suganya.K.
Subject: RE: Document link in Excel sheet
Thanks for the prompt reply. But I need a hyperlink to the Notes document rather than an icon to link to the document.
Subject: Document link in Excel sheet
When the document is open, click the address bar drop-down in lotus notes and it will give you the notes URL for the document in the form
NOTES://SERVER/DATABASEID/VIEWID/DOCID
Subject: RE: Document link in Excel sheet
Thanks a lot, Hassan. This solved my purpose.