how can i watch a mail folder for incoming email?

[Nancy Drew]

hi all

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email (something
like 't*************@acme.com') the system should write the sender's email
address, time received, and message body to sql server, return a new trouble
ticket, etc. anybody know how to set this kind of thing up?

tks

[Aaron [SQL Server MVP]]

How is the e-mail generated? If a tool generates the e-mail, can't it also
add an entry to a table, and the system can monitor the table?

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:zr********************@rogers.com...

hi all

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email (something like 't*************@acme.com') the system should write the sender's email
address, time received, and message body to sql server, return a new trouble ticket, etc. anybody know how to set this kind of thing up?

tks

[Tom Kaminski [MVP]]

"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:zr********************@rogers.com...

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email (something like 't*************@acme.com') the system should write the sender's email
address, time received, and message body to sql server, return a new trouble ticket, etc. anybody know how to set this kind of thing up?

Use the dropdirectory:
http://msdn.microsoft.com/library/en...ry_coclass.asp

.... then schedule your component/script to check it every so often.

[Curt_C [MVP]]

I think he's trying to log, and process, and incoming e-mail that comes in
via internet. Sounds like it's something he's goign to need to design from
within his mailserver, not from an ASP level... but I'm not 100% sure
either.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:uB**************@TK2MSFTNGP10.phx.gbl...

How is the e-mail generated? If a tool generates the e-mail, can't it
also
add an entry to a table, and the system can monitor the table?

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:zr********************@rogers.com...

hi all

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email

(something

like 't*************@acme.com') the system should write the sender's
email
address, time received, and message body to sql server, return a new

trouble

ticket, etc. anybody know how to set this kind of thing up?

tks

[Mark Schupp]

Are you using an email server such as MS Exchange? If so check the
documentation to see if you can set up rules to run a program on receipt of
an email.

If not, you will need to have an email client that will periodically check
for email and trigger your script when new mail arrives. There are probably
some 3rd-party utilities that can do this.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:zr********************@rogers.com...

hi all

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email (something like 't*************@acme.com') the system should write the sender's email
address, time received, and message body to sql server, return a new trouble ticket, etc. anybody know how to set this kind of thing up?

tks

[Jeff Cochran]

On Thu, 18 Nov 2004 11:11:04 -0500, "Nancy Drew" <ge*****@hotmail.com>
wrote:

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email (something
like 't*************@acme.com') the system should write the sender's email
address, time received, and message body to sql server, return a new trouble
ticket, etc. anybody know how to set this kind of thing up?

Exchange, internet, Microsoft's mail server or another vendor's, etc.?
If Exchange, this is easily programmed but not an ASP issue and an
Exchange programming group could help. If Microsoft's SMTP you could
trigger on a mail drop folder, but also not an ASP issue.

Jeff

[Nancy Drew]

the email could be from a web app, in which case i'd just copy the form
values over to sql, or it could be sent from a stand alone email client,
which is why i need to watch the mail folder for these messages and then
insert into sql

"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:uB**************@TK2MSFTNGP10.phx.gbl...

How is the e-mail generated? If a tool generates the e-mail, can't it also add an entry to a table, and the system can monitor the table?

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:zr********************@rogers.com...

hi all

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email

(something

like 't*************@acme.com') the system should write the sender's email address, time received, and message body to sql server, return a new

trouble

ticket, etc. anybody know how to set this kind of thing up?

tks

[Nancy Drew]

thanks tom. this looks like it will work, but i don't usually work with com
objects. i've getting a permissions error. there's this passage in the link
you sent me:

"You cannot change the credentials used to access a folder using the CDO
Configuration object. The current thread's security context is always used.
If you need to change security contexts to access a particular folder on the
network, you must change the thread's security context."

i intend to set up the watch process as a vbs file, running under windows
scripting host. does this mean i need to give windows scripting host
credentials to the mail folder, or the com object itself? if the latter, how
do i do that?

tks again
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:uT****************@TK2MSFTNGP09.phx.gbl...

"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:zr********************@rogers.com...

i want to build a trouble ticket system. i'd like to have a component
written in vbscript watch a specific mail folder for income email (something

like 't*************@acme.com') the system should write the sender's email address, time received, and message body to sql server, return a new

trouble

ticket, etc. anybody know how to set this kind of thing up?

Use the dropdirectory:

http://msdn.microsoft.com/library/en...ry_coclass.asp
... then schedule your component/script to check it every so often.

[Tom Kaminski [MVP]]

"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:5O********************@rogers.com...

thanks tom. this looks like it will work, but i don't usually work with com objects. i've getting a permissions error. there's this passage in the link you sent me:

"You cannot change the credentials used to access a folder using the CDO
Configuration object. The current thread's security context is always used. If you need to change security contexts to access a particular folder on the network, you must change the thread's security context."

i intend to set up the watch process as a vbs file, running under windows
scripting host. does this mean i need to give windows scripting host
credentials to the mail folder, or the com object itself? if the latter, how do i do that?

What's generating the error? Are you using the local IIS SMTP service?
Just run the script under the context of a user that has read/write access
to the folders.

[Nancy Drew]

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:O9**************@TK2MSFTNGP15.phx.gbl...

"Nancy Drew" <ge*****@hotmail.com> wrote in message
news:5O********************@rogers.com...

thanks tom. this looks like it will work, but i don't usually work with

com

objects. i've getting a permissions error. there's this passage in the

link

you sent me:

"You cannot change the credentials used to access a folder using the CDO
Configuration object. The current thread's security context is always

used.

If you need to change security contexts to access a particular folder on

the

network, you must change the thread's security context."

i intend to set up the watch process as a vbs file, running under windows scripting host. does this mean i need to give windows scripting host
credentials to the mail folder, or the com object itself? if the latter,

how

do i do that?

What's generating the error? Are you using the local IIS SMTP service?
Just run the script under the context of a user that has read/write access
to the folders.

thanks tom - i was running it as an asp page. i needed to grant IUSR read
permsissions on the drop folder. works fine now. i'll eventually convert
the asp into vbs and have to get our server admin to grant read perms to
whatever account windows scripting host runs under(?)...

[Aaron [SQL Server MVP]]

> the asp into vbs and have to get our server admin to grant read perms to

whatever account windows scripting host runs under(?)...

It runs as whoever starts the script. If you double-click the VBS file, it
runs as you. If you create a windows scheduled task, it runs as whoever is
specified in the "Run as..." field.