Automate Email treatment : Kick Off ! (1 Viewer)

Feasible to do email treatment using ms access?

  • Yes

    Votes: 1 50.0%
  • No

    Votes: 1 50.0%

  • Total voters
    2
  • Poll closed .

Johnvandamme

Registered User.
Local time
Today, 06:31
Joined
Feb 27, 2006
Messages
12
Hello,

I want to create a database that will do following tasks:

  • Import emails
  • Append in temp table with dump ID (dump ID contains folder where the mail was stored in)
  • Scan the subject of the mail (find customer & ticket ID)
  • Scan the body of the email looking for keywords : DOES NOT WORK !
  • Assign the other items to REJECTED (by doing update query)
  • Assign the record to a user dependent of the user qualifications (language, type of question;; )
  • Track the response date (service level)
  • Automate all mails OUT using word merge automatically


    Reporting :

    Overdue email to assigned agent
    Dashboard with total in and total out (easy)


    I will start creating the database structure now and think really good about the exact flow this must follow.

    But the question I have at this moment is :

    Is it feasable using Access creating an emailtreatment system?
    How automate the mailmerge in Access & Word ?
    What to do with the massive amount of KB's of the Body of the email?
    Are there a few samples that have similar functionalities ?

    Thank you all for your reactions..
 

Users who are viewing this thread

Top Bottom