This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Jul 23, 2014, 6:20 PM
3 Posts

Mail-in database form

  • Category: Application Development
  • Platform: All Platforms
  • Release: 9.0.1
  • Role: Developer
  • Tags: mail-in
  • Replies: 8

I'm working on a process whereby response data is gathered via buttons sent in emails.  The pared down button code:

Sub Click(Source As Button)
    Dim s       As New NotesSession
    Dim db      As NotesDatabase
    Set db = s.CurrentDatabase
    Dim tmemo   As NotesDocument
    Set tmemo = New NotesDocument(db)
    
    tmemo.response1 = "response1"
    tmemo.SendTo = "responsecatcher@xyz.com"
    tmemo.Form = "testForm"
    Call tmemo.Send(True)
End Sub

This works fine if the email is sent to a mail db but if the email is sent to a mail-in db, the doc is received as form='Memo' even though form 'testForm' exists in the mail-in db.  The response1 field is lost.

Is the routing to mail-in dbs restricting the ability to receive docs with forms other than 'Memo'?

Jul 23, 2014, 7:13 PM
82 Posts
A solution
Simply alias the Form name testForm|memo
Jul 25, 2014, 3:21 PM
12 Posts
Is the Form property Store Form in Document set?
From the code I see that we are including a True Parameter for attachForm when we send it.  In order for the form to be sent the document property on the TestForm "Store form in document"  on the first tab of the form properties needs to be enabled
Jul 25, 2014, 8:08 PM
3 Posts
Still received as a memo doc

Thanks for the suggestions.  When I created an alias of "Memo" for form "testForm", the doc is still received in the mail-in db with all the fields that are contained in a standard memo form (e.g. body, categories, delivereddate, MIME_version, PostedDate, etc).  The field that is supposed to be created from the button code, response1, is no where to be found.

Something in the routing of the email to a mail-in db is different (at least in my case) versus the routing of an email to a mail db.  When I use the button code to send to a mail db, the doc is received with form="testForm" and field "response1" is present and contains the sent value.  Granted, a few additional fields get added during the routing process but the fields specified in the button code all come through intact.

I did try the "Store form in document" setting to no effect.  The doc hits the mail-in db already morphed into a memo with all the memo field and none of the fields created from the button code.

Jul 28, 2014, 7:28 PM
12 Posts
Does Testform have any subforms in it
Does Testform have any subforms in it?  If so that would explain why the Store Form In Document  is not working as it can not be used with forms wiht Subforms in it.  When we look at the document properties in the mail in DB,  do we see any of the $Fields that are added as part of the Store Form in Document?  $$ScriptName, $Title,  $StoredFormCRC  etc?
Jul 28, 2014, 11:15 PM
3 Posts
No subforms

No subforms are involved in this scenario.  Also, when the doc is sent to a mail db, the form doesn't even have to be stored in the doc ( i.e. Call tmemo.Send(False) ) for the doc to be received correctly.

Jul 31, 2014, 2:45 PM
26 Posts
where is response catcher?

What server hops does hte message take?  Is the mail routing directly from notes server to notes server or is it routing via SMTP to another domain?  I tried your test internally, source mail file on same server as the mail-in db, and it worked fine.

Aug 1, 2014, 1:05 AM
8 Posts
Sending to mail-in database

If the mail-in database contains form, "testForm", set the attachForm parameters to 'false' as there is no need to store the form in the document you are sending. (This assumes that the document is not routed through SMTP.)

Nov 18, 2014, 8:17 PM
82 Posts
Enable Internet Mail server sends Notes private items in messages
'Enable Internet Mail server sends Notes private items in messages' in the server configuration document (Mime-Advanced-Advanced Outbound Message Options)

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal