Connecting to a different mailin DB in lotus notes

sorry Bosman, the call for "Principal" has nothing to do with the mail DB being used.  It simply changes the "Name" the email appears to come from.

I know. It normally works, but I don't know why it doesn't work here.

What you want with the mail database I don't understand. At the moment, you don't really use the database: the code needs "some" database to create a document in, but that's all, since the document isn't saved. In fact, you could have used ANY database. So what do you want exactly with the mailin database??

Using Lotus Notes I have my own mail database - which is for my own personal email.  call the database DeZZar82.nsf....this is an inbox, sent items, folders etc....

The code above (and all the lotus email code I've used in the past) simply uses your 'default' mail database to send the email created by the code.

However, within my lotus notes program I can not only use my own mail database...the DeZZar82 mail in database (say for arguments sake email address dezzar82@mycompany.com) but also other databases that I have access to (say CompanyEnquiries@company.com).

So the code above doesn't have a way to specify that I do not want mail sent using DeZZar82 as the mail database, but rather 'CompanyEnquiries' instead.

Don't confuse the two portions of my question. One doesn't relate to the other.  "Principal" is just a setting to let you change the 'name' the mail appears to come from.  Using other mail code I have I can specify "Principal" as Mikey Mouse and so when you recieve an email from my database it will come from "Mikey Mouse"  it will still however have used the 'default' lotus mail database to send the mail....(DeZZar82)

No, sorry, it doesn't work like that in Notes, that is to say: I sense a misconception about the mail database that you use. Which is: you DON'T really use any database at all. All the code does is, basically: an in-memory NotesDocument object is created, the object is filled and sent away, and then it is destroyed! The object is not saved to disk. Hence, you could have created that very same object in ANY database, because you don't use a form, you don't use fields, or any property or method that requires a document saved to disk. Setting doc.Form= "Memo" is just an assignment, nothing else. It means in this case that the receiving end will recognise which form should be used to open the document received. That's all.

That's why I asked my question: where does a mail-in database come in??

it is a given that you know alot more about notes than I do so I apologise for any mis-understandings.

I'll attach the code I have been using in the past to simply construct plain text emails and perhaps this might shed some light on where I am coming from.

In the code above, if I change the line:
doc.SaveMessageOnSend = False

the email being sent will be saved in the sent items of (DeZZar82@company.com) the mail file I am refering to as my default mail database and any recieving the mail will see that it has come from Dezzar82@company.com and when they hit reply it will go back to DeZZar82@company.com.  

It would not matter if my lotus notes had 4 different mail databases open (all sending and recieving mail on my machine):
(dezzar82@company.com) (enquiries@company.com) (feedback@company.com) (complaints@company.com)
The code would still manage to save in the sent item in the mail database that hosts dezzar82@company.com

In the code below the line "Set Maildb = Session.GetDatabase ("",MailDbName) seems to cleary point to the fact I could, if I knew how, set up the code to use say (enquiries@company.com) as the mail database instead of my own (my default) dezzar82.

I guess I am looking for some information on how this can be controlled and how it might be integrated into the code above that uses mime for sending html email instead of the method employed by the code below.

Private Sub LotusEmail()
On Error GoTo Err_LotusEmail
 
Dim Maildb As Object 'The mail database
Dim UserName As String 'The current users notes name
Dim MailDbName As String 'The current users notes mail database name
Dim MailDoc As Object 'The mail document itself
Dim AttachME As Object 'The attachment richtextfile object
Dim Session As Object 'The notes session
Dim EmbedObj As Object 'The embedded object (Attachment)
Dim strBody As String 'Email body text
Set Session = CreateObject("Notes.NotesSession")
Set Maildb = Session.GetDatabase("", MailDbName)
    
    If Maildb.IsOpen = True Then
    Else
        Maildb.OPENMAIL
    End If
 
'Email body text _
Need to put this into html. _
Simply adding html tags doesn't work
strBody = "Hi Bob," & vbCrLf & _
vbCrLf & "This is supposed to be a HTML email!" & vbCrLf & _
vbCrLf & "But it isn't is it?"
    
Set MailDoc = Maildb.CreateDocument
    MailDoc.Form = "Memo"
    MailDoc.sendto = "derrick.n.goostrey@nab.com.au"
    MailDoc.CopyTo = ""
    MailDoc.BlindCopyTo = ""
    MailDoc.Principal = "Mickey Mouse"
    MailDoc.ReplyTo = ""
    MailDoc.subject = "email subject"
    MailDoc.htmlBody = strBody
    MailDoc.SaveMessageOnSend = False
'   True if email to be saved in sent items
    
    
'    Include if attachements required
'    Set AttachME = MailDoc.CreateRichTextItem("Attachemt")
'    Set EmbedObj = AttachME.EmbedObject(1454, "", "C:\File path in here")
 
    MailDoc.CreateRichTextItem ("Attachement")
    MailDoc.Send 0, Recipient
 
'Clean up
Set Maildb = Nothing
Set MailDoc = Nothing
Set AttachME = Nothing
Set Session = Nothing
Set EmbedObj = Nothing
 
Exit_LotusEmail:
    Exit Sub
    
Err_LotusEmail:
    MsgBox "The following error has occured" & _
    vbCrLf & vbCrLf & Err.Number & "-" & Err.Description & _
    vbCrLf & vbCrLf & "Please report to system administration", vbOKOnly + vbCritical, "Lotus Notes Email Error"
    
End Sub

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:

just something to add to this, if I close my own default email within notes and simply leave one of the other inboxes open.  When the original code posted runs, it still manages to use my 'closed' mail file as the the place to save the sent item and the recipient of the email still sees it as coming from me "dezzar82" reply automatically selects Dezzar82 as the place to submit a reply the message

Based on what you said regarding the fact the code doesn't use a mail faile as such I would then expect the recipient to recieve the mail from some undefined name and when the hit reply it would have a blank email address as it wouldn't know "where" the email came from....?

So the comment that the system isn't using a mailfilemailin databse (whatever you want to call it)  to send the email doesn't make any sense...

and if it is supposed to just use whatever mail database is open on your machine, it doesn't explain why, when my own mail file is closed and I only have another common inbox open, that it has still used my mail file as the effective sender...

Assuming that you set SaveMessageOnSend to True,

> if I close my own default email within notes and simply
> leave one of the other inboxes open.  
The code runs in the background, and has nothing to do with the foreground Notes client activities.

> When the original code posted runs, it still manages
> to use my 'closed' mail file as the the place to save
>the sent item
Correct. This happens because the OpenMail method specifically opens the current user's mail database.

> and the recipient of the email still sees it as coming
> from me "dezzar82" reply automatically selects Dezzar82
> as the place to submit a reply the message
Ah, no, not true. There is a difference between the mail database and the current user. The current user sends the mail, so his return address will be used in the mail, irrespective of the mail database the mail will be stored in.

So there are 2 things very important:
- the current user: when a mail is sent through the Domino server, it is sent in his/her name with the right reply address
- the NotesDatabase object:  when the document is saved (which is not required for mail to work), it is saved in the database in which the NotesDocument object was created

Sorry for any misunderstandings, I might have misunderstood you. Hope this clears it up a bit.

thanks sjef it seems we're both on the same page now.

So the second snipet of code I posted is not the one I want to change the mail file on....it is the original one posted by Bill Hanson for using MIME to send HTML email.

I don't see the same: Set Maildb = Session.GetDatabase("", MailDbName)
in his code and so I don't know where to start to achieve this.  It seems to only call on notes with the following:

 Set sess = CreateObject("Lotus.NotesSession")
 sess.Initialize ("nag1999")

You may also notice that the second set of code I posted (the plain text one) doesn't require a password to be set - it just uses the open mail file - Bill Hansons code specifically calls for the password and if you leave it out your presented with a Notes message asking for a password before the message will send.  Is there any way to avoid this.

Effectively, can the original code posted be modified to work more like the second code posted in regards to setting the mail file, changing the "principal" and functioning through an open lotus notes sessions without asking for passwords etc...

You help is greatly appreciated!

Cheers
DeZZar

By the way, if this is an agent, you CAN change the sender's name: ask your admin to create an additional notes-ID for a fake person, and ask him to sign the agent using that ID. To prevent asking the admin over and over again to re-sign the agent, when you applied changes to it, you can put the real code in a script library, which you call from the agent.

So in the agent's Initialize, you only have

      Use "Agents"

      Call SendMailAgent

and in a scriptlibrary called "Agents" you put all the code, starting with

      Sub SendMailAgent
            ...
      End Sub

thanks sjef, I will check the principal settings when I'm back at work on monday.

What I find a little strage though is that, with the second set of code I posted above (the full script for just sending plain text emails) I can literally set "Principal" to whatever I want.  I could put  "MailDoc.Principal = "Slap My Forehead" and it will work, people will be getting mail from "Slap My Forehead" obviously without 'Slap My Forehead' ever actually being found anywhere in any system/address book or otherwise...

If your having trouble believing me, try the code.

So based on this, I'm not seeing any relevant connection between the setting of "Princpal" which appears to me to be simply a setting to amend the display name..(?) and the actual existance of the name a user on the servers....?

Could be, I believe you. I suppose, what should happen is that Domino retrieves the user you mention in the Principal field, fetches his or her mail address, and posts it to the other side. Anyway, that's what I am led to believe.

Setting Principal seems to need to be handled differently with MIME:
http://www-10.lotus.com/ldd/nd85forum.nsf/PlatformAllThreadedWeb/92fe3533ae6374d5852575ec006ce5d0?OpenDocument

OK well to date there is still no solution to setting the "Principal" or for all intensive purposes the "From Name" on the emails being sent with this code.

I checked the property settings on the actual emails and strangely enough, emails issued with this code do not contain "Principal" in the mail settings, instead the available settings are: (in part)
- AltFrom
- DisplayFrom
- DisplayFrom_Preview
- From

All of which are in-effectual on the actual name displayed.  Some of these settings are indeed changed by the code when sending the email (becuase they have the value set in the code when checked) but don't actually change the from name displayed.

The thread contained in the link above might provide clues to someone who knows Mime inside out, but for me it basically just shows someone had the same issue and then suddenly figured it out without bother to share the result.

So I will close this thread and live with this issue for a while longer, maybe revisit with a new thread soon.

Cheers
DeZZar.

How disappointing...

Last attempt: can you also set the InetFrom-field, to the Internet reply address of the principal?
http://www.josephhoetzl.com/topics/lotus/