title: VBA Lotus Notes sender email address as CC
body: <p>I created a makro in excel to send all TODOs to the responsible people. Now I want to add the sender address into the CC. I know how to set the CC but I don't know how to get the current sender address.</p>
  
  <pre><code>Set session = CreateObject("Notes.NotesSession")
  Set db = session.GETDATABASE("", "")
  Call db.OPENMAIL
  Set doc = db.CREATEDOCUMENT
  Call doc.REPLACEITEMVALUE("CopyTo", strEmail)
  </code></pre>
  
  <p>I think it should work with the notes session, but I didn't find any method for this.</p>