I am not sure if this is possible. I have an error query that we would like to auto-email on a daily basis. However, the Access Database is password protected, so I don't know if it can be done. I have tried the Scheduler, and it did not produce results. The Query is pulled from a switchboard button and I've created a macro that once clicked will popup Microsoft Outlook and allow you to email; but I don't think this is what I need. I'm fairly new to using Access on a daily basis, but do have a Microsoft certification in it so I do understand most of it - we just did not cover this. I am using Access 2010. Any help would be greatly appreciated!
Beth
Beth