Results 1 to 3 of 3

Thread: Sample requested.............(Notes)

  1. #1
    Guest
    I am just getting into interfacing with Notes. Can any of you that are more experienced send me some sample code that I can jump through and pick up some of the nuances?

    [email protected]

    Any help would be appreciated.

  2. #2
    Junior Member
    Join Date
    May 2000
    Location
    Oporto - Portugal
    Posts
    16
    Originally posted by Boothman_7
    I am just getting into interfacing with Notes. Can any of you that are more experienced send me some sample code that I can jump through and pick up some of the nuances?

    [email protected]

    Any help would be appreciated.

    Try http://www.notes.net or http://www.components.lotus.com

    What kind of sample ? But work both, VB and Lotus Notes

    see u

  3. #3
    Hyperactive Member billwagnon's Avatar
    Join Date
    Jul 1999
    Location
    St. Louis, Missouri, Mississippi Valley
    Posts
    290
    This is from the Lotus.com site (search on visual basic, ole, automation, notes).

    Code:
    Sub Button1_Click()
    MsgBox "this is button on my spread sheet"
        Dim s As Object
         Dim db As Object
         Dim doc As Object
    's and db declared in general as object
    Set s = CreateObject("Notes.Notessession")  	'create notes session
    Set db = s.getdatabase("", "")      	'set db to database not yet named
    Call db.openmail       			'set database to default mail database
    Mycell = Sheet1.Cells(1, 4)
    Set doc = db.createdocument  ' create a mail document
         msg = "Mail has been sent: " & Date & "  " & Time & Chr(10) &  	'these 2 lines need...
    	"The value in Cell D1 [ " & Mycell & " ] is in the body of the message"  '...to be put on one line
         Call doc.replaceitemvalue("SendTo", s.UserName) 'Notes client's user name (for testing)
         Call doc.replaceitemvalue("Subject", "Excel message")
         Call doc.replaceitemvalue("Body", msg)
         Call doc.Send(False)  'send the message	'send the message
    MsgBox doc.getitemvalue("Subject")(0) & " has been sent"
    Set s = Nothing  		' close connection to free memory
    End Sub
    [Edited by billwagnon on 05-24-2000 at 01:52 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width