I've got an MS Access DB that sends and tracks LN emails. Right now it works only by sending emails from my account, i.e., the one associated with my LN client login on my machine.
I would like to do these functions using a group mail box for which I have admin rights.
So the question is how to redirect (and or control the) access to another Lotus Notes inbox via VBA...
Testing the process of checking the inbox, and even with a hard coded .NSF file and server, it still points to default inbox.
This is the current code which looks at the users inbox: Need the ability to point to a different inbox
Set mSession = CreateObject("Notes.NotesSession")
UserName = mSession.UserName
MailDbName = Left$(UserName, 1) & Right(UserName, (Len(UserName) - InStr(1, UserName, " "))) & ".nsf"
Set Maildb = mSession.GETDATABASE("", MailDbName)
Set NotesDocs = Maildb.GETVIEW("($Inbox)")
Set MailDoc = NotesDocs.GETLASTDOCUMENT
Any help with this would be appreciated.