Manage Learn to apply best practices and optimize your operations.

Beware of using Notes e-mail for data transfers

My tip is the same except that from here onwards the agent isn't scheduled, it is an "After Mail Arrives" agent.

Bill Gordon's tip, How to use Notes e-mail for data transfers, suggests using mail to transfer data:

Create a Notes Mail-in database.
Create a form in the database called "Memo."
Create the basic e-mail fields, (Body, From, etc.) that are found in the Lotus e-mail memo.

My tip is the same, except that from here onwards the agent isn't scheduled -- it is an "After Mail Arrives" agent.

Gather the new mail in your agent by using the UnprocessedDocuments method in the NotesDatabase class. When you're done with each mail document, call the notesSession.UpdateProcessedDoc( notesDocument ) to remove the document from the unprocessed list of e-mail that has arrived.

If you can dictate the data format, try XML. I've used simple XML as the input format within the memo field, (connected to the Microsoft XML parser via OLE) by using a lookup view to match the XML tags to the target fields created in the Notes documents.

We once had a Domino intranet where people could submit content via e-mail. It would then categorize the documents according to predefined categories that it found in the e-mail. Unfortunately, someone accidentally sent a rather bad porn e-mail to the intranet and it was categorized against a high-visibility category, because the e-mail's distribution list contained a domain matching the category. Several senior managers were unimpressed when they were given a new view on "waste management."

Since the developer signed the agent, the mail notifying management of new content bore his name and he had to prove his innocence.

So beware.

Do you have comments on this tip? Let us know.

This tip was submitted to the tip exchange by member Anthony Reed. Please let others know how useful it is via the rating scale belowip. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Dig Deeper on XML and Web Services for Lotus Notes Domino

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...