Mail-in database - Is this possible?

HCL Domino Domino Forum
1

I created a mail-in database (InvScan) and and a form within this database (Invoice). Within the form I have fields Vendor Name, Invoice #, Invoice Date and a rich text field, Image. I would like to use the scan to e-mail feature of our Ricoh copier to have an invoice scanned, e-mailed to the database and have the image saved to the RTF, Image. Is this possible?

Thank you for any input.

Anita

2

Subject: Mail-in database - Is this possible?

I’ve never done this, so there maybe other things I’m not aware of:

It would seem to me the “difficult” part would be taking the arriving e-mails and determining which invoice document they belong to “append” the image (is it an image (TIFF?) or Attachment(PDF?)).

3

Subject: RE: Mail-in database - Is this possible?

Stephen,

Thank you. It would be a PDF attachment. I was unsure if this would work. I didn’t want to waste time if it absolutely could not be done.

Thanks again.

Anita

4

Subject: RE: Mail-in database - Is this possible?

If it’s a PDF then it just a matter of taking the backend documents and copying the richtext field from one to the other.

Dim rtInvDoc As NotesRichTextItem

Dim rtMailDoc As NotesRichTextItem

…

[Code magic to find right InvDoc for each MailDoc]

…

Set rtInvlBody = New NotesRichTextItem (InvDoc, “Body”) ’ Body being the RTF you’re storing the PDF into

Set rtMailDoc = MailDoc.GeFirstItem(“Body”) ’ Body being the RTF in your E-mail

Call rtInvBody.AppendRTItem(rtMailDoc)

Call InvBody.Save(False, False, False)

Again, the trick will be identifying the “Invoice” document to match with - maybe you will have that in the subject?

5

Subject: RE: Mail-in database - Is this possible?

Let me clarify. I want to scan a document and send it to a mail-in database. (That part is working.) Once in the mail-in database, I am looking for a way to Detach the PDF from the body of the message and copy (or send) it to a form in another database. So this would involve two separate databases and the detaching and copying of the PDF from the mail-in database to another database.

Thank you.

6

Subject: RE: Mail-in database - Is this possible?

If you can read and write to the documents in the other database, my code still applies.

7

Subject: RE: Mail-in database - Is this possible?

Stephen,

Thank you for the clarification and also for your guidance with this issue. Your help is appreciated.

Anita