how & where?

Posted on 2003-10-22
Last Modified: 2013-12-18

I have found a FREE PDF writer, I want to print to that PDF writer from NOTES, then in the same breath, email the PDF in the same breath basically!

Dim WshNetwork As Variant
Set WshNetwork = CreateObject("WScript.Network")
PrinterPath = "HP LaserJet 2100 Series PCL 6"
WshNetwork.SetDefaultPrinter PrinterPath
Set WshNetwork = Nothing

If this is the code to change a printer default to a printer specify, where do I put this code and how would I be able to combine the below code with...

_SendTo := SendTo;
@Command( [FileExport];"WordPerfect" ; "c:\\tempexport.doc" );
FIELD EnterSendTo := _SendTo;
FIELD SendTo := _SendTo;
@Command([EditGotoField]; "Body" );


Question by:Collenr

Expert Comment

ID: 9599140
Well, after setting the default printer you need to print the stuff using FilePrint.

This will print to the pdf file.  You cannot export to a pdf writer.

You can only print.
LVL 15

Expert Comment

ID: 9601052
No need to export.  Just do EditInsertFileAttachment with the file you create.

To tie the 2 together, you could put the @formula's in an agent, and call that agent from your script (in a button) like :

set s = new notessession
set db = s.currentdatabase
set agent = db.getAgent( "AgentName" )


LVL 31

Accepted Solution

qwaletee earned 50 total points
ID: 9602549
"Found" a free PDF Writer?  I pointed one out to you in the previous Q!

Anyway, first you have to know where the output file goes.  For teh free PDF utility I gave you, I think you have to set a variable in an INI file.  You also have to wait for teh file to be complete -- you don't want to e-Mail a file-in-progress!

The following code will e-Mil a given file:

Dim s as new notesSession
Dim db as notesDatabase
Set db = s.currentDatabase
Dim doc as notesDocument
Set doc = s.documentContext 'you may need to assign this to something else
Dim memo as new NotesDocument(db)
memo.Form = "Memo"
memo.Subject = "Yuor PDF version of the Notes document"
memo.SendTo = doc._SendTo
Dim body as notesRichTextItem
Set body = memo.createRichTextItem("Body")
body.embedObject EMBED)ATTACHMENT , "" , "c:\tempexport.doc"
memo.send false

Expert Comment

ID: 39521309
Here is the code:

Option Public
Uselsx "*lsxlc"


      cbSize As Long
      fMask As Long
      hwnd As Long
      lpVerb As String
      lpFile As String
      lpParameters As String
      lpDirectory As String
      nShow As Long
      hInstApp As Long
      lpIDList As Long
      lpClass As String
      hkeyClass As Long
      dwHotKey As Long
      hIcon As Long
      hProcess As Long
End Type

Declare Function ShellExecuteEx Lib "shell32.dll"_
Alias "ShellExecuteEx" (SEI As SHELLEXECUTEINFO) As Long

Declare Function TerminateProcess Lib "kernel32"_
Alias "TerminateProcess" (Byval hProcess As Long, Byval uExitCode As Long) As Long

Sub Initialize
      On Error Goto ErrorHandler
      SEI.cbSize = Len(SEI)
      SEI.lpVerb = "print"
      SEI.nShow = 1
      SEI.hInstApp = 0
      SEI.lpIDList = 0
      Dim s As New NotesSession
      Dim session As New LCSession
      Dim db As NotesDatabase
      Dim object As NotesEmbeddedObject
      Dim dc As NotesDocumentCollection
      Dim doc As NotesDocument
      Dim downloadfolder As String
      Dim extrachar As String
      Dim filecounter As Integer
      Dim filecount As Integer
      Dim filen As Variant
      Dim antalfiler As Variant
      Dim i As Integer, x As Integer, y As Integer
      Dim sFile As String
      Dim uidoc As NotesUIDocument
      Dim ws As New NotesUIWorkspace
      Dim success As Variant
' Create a folder for temporary storage of files
      downloadfolder = Environ("tmp")
      Set db = s.CurrentDatabase
      Set dc = db.UnprocessedDocuments
      For i = 1 To dc.Count
            Set doc = dc.GetNthDocument( i )
' Print document
            Set uidoc = ws.EditDocument( False , doc , True , )
            Call uidoc.Print(1)
' Get all attachments and print them
            antalfiler=Evaluate("@Attachments", doc)
            Call uidoc.Close
            Delete uidoc
            If antalfiler(0)>0 Then
                  For filecounter=0 To antalfiler(0)-1
                        Set Object = doc.GetAttachment( filen(filecounter) )
                        If ( object.Type = EMBED_ATTACHMENT ) Then
                              fileCount = fileCount + 1
                              If Dir(downloadfolder+"\"+ filen(filecounter))="" Then
' Extra character in case there are attachments with the same name
                              End If
                              Call object.ExtractFile (downloadfolder+"\"+extrachar+ filen(filecounter) )
                        End If
                  Next filecounter
            End If
            For y = 0 To filecounter-1
                  sFile = downloadfolder+"\"+extrachar+ filen(y)
                  SEI.lpFile = sFile
                  Call ShellExecuteEx(SEI)
                  Call session.Sleep(2000)
' Delete all files
            Call session.Sleep(5000)
            For y = 0 To filecounter-1
                  sFile = downloadfolder+"\"+extrachar+ filen(y)
                  Kill sFile
'Call TerminateProcess(SEI.hProcess, 0)
      Exit Sub
      Msgbox Error$ & " on line " & Cstr(Erl) & " in " & Lsi_info(12)
      Exit Sub
End Sub

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question