If you are interesting in automating via some Java Technologies, following
are a couple of links that could be usefull.  They are also free.

http://java.sun.com/products/javamail/

http://james.apache.org/

A program can be created with the JavaMail api that will poll your mailbox
that the rejected e-mails are being sent back to.  The e-mail automatically
parsed into a java.mail.Message object.  Header info can be retrieved,
contents can be easily parsed.

The James product is an email server framework.  James can be configured to
be an smtp receiver as well as sender.  If you set your from address to be
an address on the James server, the reject emails can be retrieved in real
time.  No polling is necessary via pop3.  For James you just create
a "Mailet" listener.  James will pass a Mailet to your listener when it
receives a mail message from an smtp sender.  This Mailet uses the very
same JavaMail api that I mentioned above.  You get a java.mail.Message
object from the Mailet.  As above you can get the info needed from this
message.

In either case, you could store info in files, databases, whatever you wish.

For starters I am guessing that you may want to append address/subject info
into one file, and perhaps append the entire e-mail contents into a second
file for reference.

You could even update the image db immediately if so desired, but I believe
from your message that you want a user reviewal process.

Just my 0.04

Evan Vaala


On Fri, 5 Sep 2003 12:02:29 -0400, Janie Shuman
<[log in to unmask]> wrote:

>We download a file of students from our Image database into EXCEL and from
>this file send emails.  Many of these emails are rejected for bad
>addresses.  We are trying to find a cost and time-efficient way of deleting
>the addresses from the database.  Is there a way to have rejected addresses
>feed into a file?  I was told that you can purchase software for this task,
>but that it is very expensive.
>
>At present they are printing the returned ones, using a "find" command in
>the EXCEL file, coding them to be deleted in the EXCEL file, and then
>looking them up on a screen that accesses the IMAGE database in order to
>delete them.  For various reasons, we need to find a better way.  I The
>EXCEL file allows only 1 person at a time, and the data entry people are
>not accustomed to EXCEL.  They are more comfortable with their usual
>screens which access the Image database.  I explained that I could transfer
>the EXCEL file to the HP, and automatically delete the records from the
>database.  But they've asked for a screen on which to look them up using
>just the email address, which isn't a key.  And they'd like to be able to
>use only part of the email address if possible.  Presently we only have key
>lookups on our screens, and I'm not sure how to do this.
>
>If I could just get the rejected email addresses in a file, I'd be able to
>automate the solution entirely.
>
>Anyone have any ideas or knowledge of resources for this issue?
>
>THANKS!
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *