Solved

Trap emails

Posted on 2002-07-03
10
555 Views
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.
0
Comment
Question by:ManishRanjan
  • 3
  • 3
  • 2
10 Comments
 
LVL 2

Expert Comment

by:pforeman
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.
0
 

Author Comment

by:ManishRanjan
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.
0
 
LVL 2

Expert Comment

by:pforeman
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.

OR

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.

OR

If you use an Intranet, setup a web based application/solution to use web based forms to send / receive emails.
0
 

Author Comment

by:ManishRanjan
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.
0
Do email signature updates give you a headache?

Do you feel like all of your time is spent managing email signatures? Too busy to visit every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

 
LVL 2

Accepted Solution

by:
pforeman earned 50 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
http://www.win2000mag.com/Articles/Index.cfm?ArticleID=21522

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.

//PF
0
 
LVL 10

Expert Comment

by:HDWILKINS
ID: 7133437
Hi,

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.

HW
0
 

Author Comment

by:ManishRanjan
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.

Comments!!!

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


0
 
LVL 10

Assisted Solution

by:HDWILKINS
HDWILKINS earned 50 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.

HW





0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In this video we show how to create a mailbox database 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 Servers >> Data…
To show how to create a transport rule 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 Mail Flow >> Rules tab.:  To cr…

762 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now