Excel and Outlook Script

[dean41]

Hi,

 

We currently look after a site with just over 300 MFDs which don't self order toner. We have a bit of software that will interrogate the machine and email us when the toner is out. Most of the building have a central store where the staff will go and collect a toner from and install it themselves. At the moment we have a basic spreadsheet with the stores on and the quantity of toner in them.

 

So my question is, is there anyway we can automate this with some sort of script so when an email comes through outlook will run a script to minus a toner from the toner store?

 

Bit of a long i know.

 

Cheers

[dapaulio]

Not too sure how that would work logistically. That would rely on someone changing the toner after the first email. If it interrogates daily and emails you daily. If you miss the email ln friday it wouldnt get replaced until monday but would have reduced stock by 3 when only one was taken.

 

As a suggestion I would be inclined to write a small program/access database what ever takes you fancy on a touch screen computer located in each of the stores.

Simple database that has two button what toner has been taken and where too. This could email you a confirmation. With stock levels

 

When you receive a delivery a technician signs the toner in to the store again emailing a confirmation with stock levels.

 

This however would rely on staff actually signing it out properly but with discipline would actually work the way you want it to