General discussion

Locked

Office / Exchange Collaboration

By mferrel ·
Have MS Exchange 5.5 and Office 2000 at disposal. Need to set up an automated scenario to accomplish the following:
- Sales fill in job info; customer info; type of product requested; color; amount; date to be delivered, etc.
- This info is automatically sent to MFG; ENG; ACCT for approval
- If anyone cannot approve for any reason (price, parts availablity, ship date...etc), Then the original must be automatically sent back to MFG; ACCT; ENG; SALES with the rejection, the reason why and ammendments (ie. can't ship by the original ship date of 11-2-2000 but could do it by 11-14-200)
- MFG; ACCT; ENG; SALES must again aprove/disaprove. If disaprove above process repeats,etc. if approved a final form representing the approved date is sent to everyone.

Dows this require Exchange scripting? (I have 0 experience with that), combo of Outlook folders and a word or excel doc? What steps need to be taken?

This conversation is currently closed to new comments.

19 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Office / Exchange Collaboration

by mferrel In reply to Office / Exchange Collabo ...

Point value changed by question poster.

Collapse -

Office / Exchange Collaboration

by ComputerDude In reply to Office / Exchange Collabo ...

Using only the tools you mention I would use access and build a database that all can view and update what is neccessary. You can add code to the access database to e-mail status if needed. Such as new sales and approval/rejection. After e-mail is recieved the various depts. would make the appropriate changes to the sales record and the process would be repeated or complete. The details of such a project would be way too much for a message board. Get a good book on Access or VBA.

Hope this helps,

Dave

Collapse -

Office / Exchange Collaboration

by mferrel In reply to Office / Exchange Collabo ...

Poster rated this answer

Collapse -

Office / Exchange Collaboration

by DoubleDown In reply to Office / Exchange Collabo ...

possibly creating a custom outlook form may help you. but someone's got to create it. there are a number of resources that will explain forms in more detail.

Collapse -

Office / Exchange Collaboration

by mferrel In reply to Office / Exchange Collabo ...

Poster rated this answer

Collapse -

Office / Exchange Collaboration

by rappenp In reply to Office / Exchange Collabo ...

It really looks like what you are looking for is a manufactoring package.. I cound find you someone to write a distbustion form for exchange (this is done in VB). but I think it would be poorly spent money quit trying to piece it together and go buya real manafactoring/accounting package

Collapse -

Office / Exchange Collaboration

by mferrel In reply to Office / Exchange Collabo ...

Poster rated this answer

Collapse -

Office / Exchange Collaboration

by ohJani In reply to Office / Exchange Collabo ...

i'm currently developing almost the thing you mentioned, the only different is that i'm routing Sales Order instaed of Job Info. i use VB6 to create the componets, put them in MTS. while using Outlook forms to create the Sales Order Form in order to send thru email. i also use Outlook Script in the OL form and send it thru Exchange Server 5.5

Collapse -

Office / Exchange Collaboration

by mferrel In reply to Office / Exchange Collabo ...

Poster rated this answer

Collapse -

Office / Exchange Collaboration

by mferrel In reply to Office / Exchange Collabo ...

ohJani, you seem to be on the track I was hoping to look into...can you contact me? mferrel@kentdisplays.com

Back to Software Forum
19 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums