JennyEx
09-05-2020, 07:28 AM
Relatively new to this forum. I'm excited to be here, and hope that members are proud to share their expertise. I am a novice VBA user, having worked mostly in the Excel environment. I have learned and appreciated the power of VBA and everyday I'm finding ways that it could improve my daily processes.
Here is one. Please tell me if it's a pie in the sky idea, or something that VBA can accomplish.
I have a large Excel based database that host employees scheduled absences. With so many people relying on these employees, especially now when so many are working out of the facility, many will fail to know that a particular employee is absent. Individuals would have to voluntarily access Excel and pull up the database to query an employee's attendance.
Every employee used Outlook exclusively. It's likely the first application they open once they login. I'm wondering, with VBA, through Outlook, can a process be created that when a particular user (authorized users only) fires up Outlook, a message pops up, or an email is generated to them, that presents absent employee information to that user.
Perhaps that's not possible. But perhaps from my machine, I can automatically generate these emails for distributione each morning. I just think that the fact that everyone uses Outlook, its a good way to provide daily information in an automated way, where from the client computer, or from the source.
If it's possible, perhaps provide a brief explanation of the process, and perhaps some key terms I can Google or online references I can research to get me started.
Thank you all in advance for your perspectives.
Here is one. Please tell me if it's a pie in the sky idea, or something that VBA can accomplish.
I have a large Excel based database that host employees scheduled absences. With so many people relying on these employees, especially now when so many are working out of the facility, many will fail to know that a particular employee is absent. Individuals would have to voluntarily access Excel and pull up the database to query an employee's attendance.
Every employee used Outlook exclusively. It's likely the first application they open once they login. I'm wondering, with VBA, through Outlook, can a process be created that when a particular user (authorized users only) fires up Outlook, a message pops up, or an email is generated to them, that presents absent employee information to that user.
Perhaps that's not possible. But perhaps from my machine, I can automatically generate these emails for distributione each morning. I just think that the fact that everyone uses Outlook, its a good way to provide daily information in an automated way, where from the client computer, or from the source.
If it's possible, perhaps provide a brief explanation of the process, and perhaps some key terms I can Google or online references I can research to get me started.
Thank you all in advance for your perspectives.