Change Lotus notes email account

[presuming_ed]

I have an application which emails reports out through Lotus Notes which on the whole works fine. My problem is that I want the author of each email to be different to the current users username and maildbname. I've tried overriding this in the code but it still seems to set the sender as the current user. Anyone got any suggestions? The following is a snapshot of my code without the overrides. Thanks.

'Get the sessions username and then calculate the mail file name.
'You may or may not need this as for MailDBname with some systems you can pass an empty string
UserName = Session.UserName
MailDbName = Left$(UserName, 1) & Right$(UserName, (Len(UserName) - InStr(1, UserName, " "))) & ".nsf"

'Open the mail database in notes
Set Maildb = Session.GetDatabase("", MailDbName)
If Maildb.IsOpen = True Then
'Already open for mail
Else
Maildb.OPENMAIL
End If

 

[presuming_ed]

Please ignore this. I've found the solution in the following thread:

www.access-programmers.co.uk/forums/showthread.php?s=&threadid=39422&highlight=lotus+account

I guess I should've searched a bit harder before I posted my question.

Thanks.