Set up Series of events

[GreenBoy]

Hi

I hope I can make this clear - obviously it is easy to make an event repeat in Outlook calendar, however what I need it a fast way to set up a series of linked events.

To explain.

I receive a request to price some information and I have 5 workdays to confirm receipt of instruction and ask for clarification or missing information.

Following this when I receive a response from the initiator I then get 2 workdays to produce the price, following this I then have 5 days to reach agreement with the initiator on the price and scope of works.

I have other tasks that follow this but you get the picture.


Given that on any day I can receive up to 10 requests I can be working on a lot of these at any given time and have projects at any of the stages above.

So Is there a way of creating a series of events/ deadlines like this in one hit i.e. fill in a form with a couple of basic details and hit Go to create the series of events.

I appreciate this may need some VBA code or an add in, but I am happy with any suggestions / help at this stage.

If there is an alternative way to go about this I am open to all suggestions.

Thanks
GreenBoy

[johnv]

Hi Greenboy,
Yes I think you can do that in vba e.g. macro and a custom appointment form in Outlook.
A couple of check boxes in the form for the logic, a GO button and some code that responds to the button to do the magic based on the selections. Basic workflow solution realy.

regards,
John