473,227 Members | 1,652 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,227 software developers and data experts.

how can i watch a mail folder for incoming email?

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
Jul 22 '05 #1
10 4172
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

Jul 22 '05 #2
"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.
Jul 22 '05 #3
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


Jul 22 '05 #4
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

Jul 22 '05 #5
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
Jul 22 '05 #6
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


Jul 22 '05 #7
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.

Jul 22 '05 #8
"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.
Jul 22 '05 #9

"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(?)...


Jul 22 '05 #10
> 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.
Jul 22 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: manatlan | last post by:
In an intranet/lan, i'd like to put a "python server script" (which run forever) on a computer A... On another computer B, I'd like to send smtp-email to the computer A ... (send to...
0
by: Ajit | last post by:
Is there anyway to move attachments from a incoming email into a specified folder using System.Web.Mail ? has anyone done this ? Any help is appreciated.
3
by: RN | last post by:
I am tired of sending mail from the built-in SMTP service for so many reasons (errors are nondescriptive in the event log, it doesn't let me control which IP address it sends from, and it...
8
by: Ajit | last post by:
Is there anyway to move attachments from a incoming email into a specified folder using System.Web.Mail ? has anyone done this ? Any help is appreciated.
2
by: Vanessa Lee | last post by:
Hello, Is it possible to write a script using CONDTS object to read all emails from the SMTP IIS "Drop" folder without changing the username and email address in LogonSMTP? or is there...
0
by: job kazan | last post by:
Can anyone suggest the best and easiest platform for the following job, possible freelancer and approximate budget for this: "It must be a script that has as an input a long code from the...
11
by: ibiza | last post by:
Hi all, I am trying to use the System.Net.Mail class for the first time, with ASP.NET 2.0. I setup everything according to http://www.codeproject.com/aspnet/EasySMTP_package.asp, which gives...
1
by: =?Utf-8?B?QW5ndXM=?= | last post by:
New user. Where do E-mails go once they are no longer seen on E-mail incoming mail screen? Are they automatically saved in some folder? If so: what is the name of that folder? Thanks, Angus
0
by: Danigan | last post by:
Is there a way I can set up Apache to put incoming emails into a folder as individual text files (MIME, text, or I guess it'd be cool if Apache has a module to throw it into a database like mySQL...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.