Hi All
I have an excel spreadsheet which holds details of peripheral devices stock levels such as mouse keyboard etc.I need to be able that when levels of stock reach a certain level it sends an e-mail automatically to notify that the stock level has fallen below a certain level
Thanks

Brendan Bartley

__________________
Brendan Bartley

1. How is the database pullig data from the Excel spreadsheet?

2. What is the trigger event to send the email? Basically you can have a form run out and get the data on a timed interval.

3. Why store the data in an Excel spreadsheet instead of an Access database? If it were in Access, when a tech took an item from inventory and updated the Access database, then you could check the level and send an email as it was changed.

4. I think if you connect to an Excel spreadsheet with Access, it makes the spreadsheet read-only, except for Access, so users may not be able to update the spreadsheet as you monitor it. That is why you pull data periodically.

5. Sending email from Access is easy. Do you need to know how to do this? If so, what email application are you using? Can you use SMTP and anonymous accounts? That always works better than Outlook integration.

Does this help?


mmcdonal