Help writing a Script to forward e-mail
From: Mike Perry (_at_)
Date: 10/18/04
- Next message: Tim Newman: "destroying objects within a class"
- Previous message: JHP: "Re: Checking to see if a network path exists"
- Next in thread: Jeff Cochran: "Re: Help writing a Script to forward e-mail"
- Reply: Jeff Cochran: "Re: Help writing a Script to forward e-mail"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 18 Oct 2004 14:53:29 -0500
As the system administrator for my company any e-mail which is returned as
undeliverable is automatically forwarded to me. If the message was
originally created by an employee they also get a copy of the NDR so I am
not concerned about those but from time to time I get a NDR on a message
that was sent by an automated system (typically an order confirmation
message that is sent to confirm that we recieved an order from the customer
via our e-commerce site) and in that case I have to run an ODBC query on the
database using the intended recipient's e-mail address as the variable to
query for and that gets me the customer number which in turn gets me the
sales person's name and then I have to contact the sales person involved and
notify them that they need to contact their customer and acquire a valid
e-mail address and then update our CRM software with the current e-mail
address.
Seems to me that this can be automated at least to some degree via a
script - I could create a special e-mail inbox and direct bounced messages
to that and then a process could run which would check for messages in this
special mailbox, grab the intended recipient's e-mail address from the NDR
message, query for the sales person's name and then forward that NDR message
to them along with a message from me instructing them to update the
customer's records in our database with a correct e-mail address.
Anyone have any thoughts on a script that would do this? I can write the
VBS that does the query and gets the sales person's name, but I am not sure
how to access the Exchange Server and this special mailbox I would create,
look for any messages, find the intended recipient's e-mail address on those
messages and then instruct Exchange to forward the NDR message along with my
mesage.
Any help steering me in the right direction would be greatly appreciated.
- Next message: Tim Newman: "destroying objects within a class"
- Previous message: JHP: "Re: Checking to see if a network path exists"
- Next in thread: Jeff Cochran: "Re: Help writing a Script to forward e-mail"
- Reply: Jeff Cochran: "Re: Help writing a Script to forward e-mail"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
