Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Trap emails

Posted on 2002-07-03
Medium Priority
Last Modified: 2010-03-05
Can we develop a system using Exchange Server 5.5 and MS-Outlook in which we can trap emails for same subject and store those mails in databases? So that we can use the whole communication from the database.
Question by:ManishRanjan
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2

Expert Comment

ID: 7129392
Using rules in Outlook you can do an action relating to a subject line.

However what actually do you need in the Database and what do you need to do to it.

Author Comment

ID: 7129560
I need to store all communication for particular subject into the database. I want to provide my users a special form for the input mails. They will send mails to other user of same domain. I wanted to archeive the communication (in database) between them for a particular subject So that in future we can use those communications for reference.

Expert Comment

ID: 7129863
If you want to develop a quick and easy system (Without to much development) I suggest using outlook rules to send all such emails to a public folder.  Which you can then use as a communication history.  However this will mean a visit to every workstation.


Using VBA a system such as the one you want could be writen.  However this would mean using a specific 'New Email' form that would check if the subject line was 'xxx' then run a particular action. (ie:- Post the email data to a DB etc)
This could cause reduction in performance in everyday use and other problems if the user uses the standard 'New Email' form.


If you use an Intranet, setup a web based application/solution to use web based forms to send / receive emails.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why


Author Comment

ID: 7130937
Thank you very much for the support

The first one is not possible because it is not possible to visit all the workstations.

I am thinking on the Second solution you have suggested, Please elaborate!!!

The third one:We don't want setup web based application/solution. I know it would be the easiest solution.

Accepted Solution

pforeman earned 200 total points
ID: 7131935
Even though I can program, VBA is not my thing So I can not expand my answer to cover code.
However if you look at http://www.slipstick.com/dev/customimport.htm (Outlook Access Data Transfer) It may push you in the right direction.  Slipstick is an great outlook/exchange site if you are in the trade... ;o)

Fundamentals for writing VBA for Outlook macros

Hope this helps. Maybe post another question in the http://www.experts-exchange.com/visualbasic/ area asking how to pass data from an outlook form to a Database.

LVL 10

Expert Comment

ID: 7133437

The answer is yes.  It will take some thought and some programming.  I'd use VFP (Visual Foxpro).

Unless you are an experinced programmer, I doubt its possible for you to get enough help from ee to do this.  Its a complicated process involving lots of little parts.

If I understand it, all of this mail is internal??

In general, Somehow you need to get all the mail into one container.  I can think of several ways.  

Either getting off the server (there are several directories where the messages are copied to in a readable text format and you could open up each file, read read it line by line and put the information in a database.

Or, creating an Outlook form that would force a bcc to a mailbox,

Or, if you were lucky enough and all of these messages were just getting sent to one mailbox and you had control of it.

If that were the case, then I'd use a mapi tool to read the mail and dump it into a dbf.  

You really need to define where your going to get to the data and once you've done that, its simply a matter of some hard work to get it done.


Author Comment

ID: 7133564
Thanks again for the support.
I have planned the work flow. A VBA form will be developed in the Outlook for special uses only and published globally. User will have the facility to use standard as well as the special form to send their mails. I will pass a hidden value (say specialmail=True) from the new developed form. On Exchange server I will track each and every mails. If it is a special mail then I will process it. To process this mail I can wrtie a Visual basic program.


By the way the 'force a bcc to a mailbox' is really nice idea.

LVL 10

Assisted Solution

HDWILKINS earned 200 total points
ID: 7133954
Several thoughts.

Send several messages from several different workstations to wherever.  Insert a unique key word in either the body or the subject of each message.  Some word that would never normally be used.

Then, go to the mail server Start/Find and scan all the drives of that server and look for the keywords inside every file.  You may find your messages in a container.

So, if you find the messages in that container, (they will all be in individual files and all in one or two places) you can then write a program that will inventory those files.  Once you inventory the files, you can write a program to scan any new files to the inventory for your subject line and take action on it.

Thats just one idea. I know that the directorys exist, and I don't remember their names or paths (but I think that they are 'archive' folders under something else. (If I had a mail server here next to me, I'd tell you in a second.)

If that doesn't work, and you choose to use an Outlook form and send the mail to a bcc your going to need to be able to read the mail into your software.  Take a look at some of the tools at http://www.nbcsoftware.com/  I think you might find what you need here and they are for the most part free.  (I just started using one in a program I'm doing).

I'd absoulutly use Visual Foxpro and not VBA on the collection side.



Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question