Wednesday, August 3, 2011

Sending a Lotus Notes document via Email

If you're in a shop that uses Lotus Notes for applications, but MS Outlook for email, you realize pretty quickly that a lot of functionality is lost when the user has to go from one to the other. In this instance, we want to send a Lotus Notes document as a MS Word document.

In the first step, we can use part of the previous post ( see part 1 here ).


REM {  Set some basic variables };
 emailTo := "Test@***.com";
 emailSubject := @GetField("Form");

REM {  Replace spaces with %20, which Windows/web understand as spaces };
 emailSubject := @ReplaceSubstring(emailSubject; " "; "%20");

@Command([FileExport];"Microsoft RTF";"c:\\Folder\\FileName.doc");

@Command([Execute]; "OUTLOOK";"/a c:/Folder/FileName" + 
   uid + ".doc /c ipm.note /m " + emailTo + "&subject=" + emailSubject)

Image of what a final solution may look like.

MS Word should recognize that the document is rtf, but treat it like it's a compatible MS Word document. Also note that your form should be in tables of no more than 6.5 inches in width. The Rtf/Word document will not understand the Lotus Notes "Fit to Margins" settings and the text and tables will overrun the document. Putting everything in pre-formatted tables in your Lotus Notes document design is the best way to avoid it.

No comments:

Post a Comment