Re: Help writing a Script to forward e-mail
From: Jeff Cochran (jeff.nospam_at_zina.com)
Date: 10/19/04
- Next message: Roland Hall: "Re: File Upload - Security Issues"
- Previous message: Tim Newman: "Re: destroying objects within a class"
- In reply to: Mike Perry: "Help writing a Script to forward e-mail"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 01:43:01 GMT
On Mon, 18 Oct 2004 14:53:29 -0500, "Mike Perry" <mperry @ nospam
smartwire.com> wrote:
>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.
Might look into using CDO to access the inbox and parse the messages.
The Exchange folks will likely point you to some decent resources for
this.
Jeff
- Next message: Roland Hall: "Re: File Upload - Security Issues"
- Previous message: Tim Newman: "Re: destroying objects within a class"
- In reply to: Mike Perry: "Help writing a Script to forward e-mail"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
