The solution that works the most easy is to make a some web-based program running on your Intranet.
Hello, since short, in our company we have the possibility to order sandwiches/dishes from a caterer on friday. there are over 100 employees and this takes up way too much time. I would like to automate this system a bit. Maybe some of you could give me help.
The idea is this:
Every department (average 7-10 pple) has a list with the available sandwiches/dishes/desserts,... With a mouseclick, the items on this list are copied to a separate file (Notepad or something simple). Every department sends this file to the secretary, and she mails the separate list to the caterer.
After delivery (packaged separately per department), they can sort out amongst themselves who ordered what.
Any tips are greatly appreciated.