Hi all,
I am planning out the stages for an application at work, the application
needs to detect when a client has emailed 'us' and then trigger a new row
written to a database and email the client back by return.
I can see how most of what our application needs to do can be achieved with
ASP/SQL Server - but the part I am unsure of is the email detection...I
suppose the closest thing to what we are aiming for would be one of those
'helpdesk' apps that many companies have - you email them - you get an
automated confirmation email back by return with a ticket number etc etc -
anyone got any ideas on how I can achieve this?
Thanks in advance for any help.
Regards
Robb 4 1655
I should have added, obviously replies to emails being sent back and forth
from client to 'us' would need to be recorded also - ie, we'd detect the
ticket number/id in the subject etc...
I've never done this, but I'm willing to pass on what
little I do know.
You would need to have some kind of email service. This
could be something as simple as an email account from your
ISP. (POP3)
Then you would write code that would check that email
account on a regular basis. There are many packages
available on the internet (some free) that allow you to
access a POP3 account from VBScript. Do a search at www.aspfaq.com, www.aspin.com. Part of this would also be
the code to update your database and send any response
emails necessary.
If your server is an exchange server, there are many 3rd
party tools that will allow you to "read" your exchange
inbox and process accordingly. In fact, there are examples
of how to access your exchange folders on Microsoft's web
site.
I hope some of this has at least given you an idea of
where to go from here.
John -----Original Message----- I should have added, obviously replies to emails being
sent back and forthfrom client to 'us' would need to be recorded also - ie,
we'd detect theticket number/id in the subject etc...
.
Thanks all for the replies.
Can anyone provide any links to 'free' components that I could use whilst
trying to test/develop this - happy to buy one when I know its all going to
work - but the one at serverobjects.c om is a bit pricey for purely testing
purposes...
Still not sure that ASP is the way to go with this to be honest, I dont
think I can write something in ASP that will dynamically check for emails
without literally having a window open all the time and refreshing it...I
guess I need something else in between that does the check and does the
database update :o/
Thanks again for the replies.
AspPop3, since it is a com dll can be used in a VB program - which you can
simply run on a schedule. I did something similar, but actually used it
from an Access (VBA) module - which was convenient since I could also save
off the emails in a table in the very same database. In that case, you make
a macro in Access that runs the code module, and schedule a batch file that
does something like:
c:\Program Files\Microsoft Office\Office10 \msaccess.exe" mymailchecker.m db
/xmcrcheckmail
Mike
"Robb Meade" <ro********@NOS PAMkingswoodweb .net> wrote in message
news:3r******** *************@n ews-text.cableinet. net... Thanks all for the replies.
Can anyone provide any links to 'free' components that I could use whilst trying to test/develop this - happy to buy one when I know its all going
to work - but the one at serverobjects.c om is a bit pricey for purely testing purposes...
Still not sure that ASP is the way to go with this to be honest, I dont think I can write something in ASP that will dynamically check for emails without literally having a window open all the time and refreshing it...I guess I need something else in between that does the check and does the database update :o/
Thanks again for the replies.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: H |
last post by:
Hi All,
Is it possible to detect a users regional settings, in particular -
Currency?
Thanks!
Hellen.
|
by: Frank |
last post by:
Hello,
I'm a total newbie on Javascript, and with a lot of help and some copy
and paste managed to get things running.
On my site: http://home.wanadoo.nl/homepage I use a form from
Bravenet. This works fine.
Unfortunately some persons fill in their e-mail address instead of the
URL of their page. Checking is done on empty fields but how to avoid
|
by: Sandeep Arya |
last post by:
Thanks linuxfreak and sybren for positive comments
My application will be running on Linux.
How to send ICMP ECHO as broadcast packets. I do not know this. Please tell
me how to?
Sybren.. Does nmap is available on every systems? I tried on my linux fc4
machine in user previleage. it was not working. Does this just belongs to
superuser...
|
by: raptor |
last post by:
hi,
how to detect opera..it seems that even opera8 doesnt support
xmlhttp fully (.i.e. sendRequestHeader). I ask this 'cause opera
seems to mimic IE, at least in the preferences ?!
I havent used opera till now, but it seems very buggy piece of software
!!
I have one very annoyng problem, fighting already ~4 hours.
I found that if I use something like this in table (test are
|
by: needin4mation |
last post by:
Hi, I have an asp.net 1.1 application that populates data from a
database. When the user changes data, they have to hit a button to
update the data. The data entry form (same form that is populated) is
from several different tables. To the user, of course, this is not
seen.
Scenario: After the page is populated, assume a change is made to the
form and the user hits update. The page then goes back, reads the
database for that record...
| |
by: jcrouse |
last post by:
I am using the following code to move a label on a form at runtime:
If myMousedown = lblP1JoyRight.Name Then
If lblP1JoyRight.BackColor.Equals(Color.Transparent) Then
bTransCk = True
lblP1JoyRight.BackColor = clrLabelMove
|
by: VK |
last post by:
I wandering about the common proctice of some UA's producers to spoof
the UA string to pretend to be another browser (most often IE).
Shouldn't it be considered as a trademark violation of the relevant
name owner? If I make a whisky and call it "Jack Daniels", I most
probably will have some serious legal problems. "Mozilla" partially
appeared because NCSA stopped them from using "Mosaic" in the UA
string.
Is it some different...
|
by: LJ |
last post by:
Hello,
I'm trying to monitor my gmail account to know when I have obtained a
new email. It seems that once I have logged in, I should be able to
call the stat() function repeatedly to see how many messages are in my
inbox. The problem is that this number does not seem to update until I
have logged out, and logged back in. In other words, I run the code
below, send myself an email, and observe that the count does not
change. If I...
|
by: Diego Martins |
last post by:
Hi all! I am doing a crude investigation of memory leaks in objects
created by external libraries.
Since I don't have access to the source code, I can't tell if an object
are freeing its resources properly during destruction.
For now, I need a portable function that can tell me the available free
store memory. With that, I can do things like:
size_t mem = getFreeStoreAvailable();
{
|
by: Manny Klystron |
last post by:
I'd like to use Database Mail to contact subscribers, but need to know
if Exchange couldn't deliver an email (bad address, etc). With SQL
Mail you can read the inbox for that, but are there any slick ways to
do it with Database Mail?
If not, I presume my options are a .NET windows service, or SQL Mail
(deprecated and ugly).
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |