apps in exchange

[rzen]

given:<br>
<br>
a branch of a large company is in need of an e-mail based application. the system is expected to <br>
<br>
- receive submissions of new requests from people outside the branch;<br>
- have a branch employee approve request;<br>
- forward for additional processing to another department;<br>
- upon receipt notify appropriate parties;<br>
- requests need to be archived after X number of weeks;<br>
<br>
request is a medium-sized form of about 150 fields with occasional ms-word or other-type attachments.<br>
<br>
the system will be mission critical, so clustering or some other means of high availability here would be definitely a plus.<br>
<br>
has anybody had experience dealing with similar projects with exchange? any caveats? can it even do this?<br>
<br>
thx!

 

[Pistol34]

I am far from a expert programmer, but have developed a Request form for use by about 250 users. I have a 3&quot; binder full of all the different ways to produce apps for exchange server. The question I have, is this system 100% exchange servers and clients or do you need a more independent app?<br>
<br>
If the entire company is running exchange server with Outlook 9x or 2000 clients the request form could be done with VB script. I used script for my form, but now wish I had used VB instead. Outlook has a task request form that can handle almost everything you want to do. The task request form originator sends the request, the request is then accepted or declined. The originator is notified of the status. The reciever then assigns the task to the appropiate party. At this point everyone who has touched the request is notified and the request is then updated automaticly. Your program is very possible.<br>
<br>
For archiving you can connect to any type database. ADO, DAO or ODBC is available in VB script. MS access and outlook have import and export wizards to help share data.<br>
<br>
If you need more info or links. Just ask with anthor post!<br>
<br>
Pistol<br>
<br>

 

[DougP]

I would Use Microsoft Access as the Glue to hold the whole thing together.<br>

I can works with Word And Outlook which would then use Exchange to send and recieve e-mail.<br>

It can be programmed in VBA to automate everthing and has great Security and Database capabilities as well as Import and Export and form and report creation.<br>

Plus there is a fantastic Site on this forum for helping you with Access. Use the Find a Forum search box on the left to get to it.<br>