Jase Alexander
asked on
Excel VBA Outlook - Scheduling an email to email contents of a cell from a workbook at specific time of day
Hi Experts
I have a basic performance monitoring sheet that calculates an average percentage based on tasks completed in cell P82
I have used VBA on other files that creates an email from a section of the sheet or by attaching the sheet itself.
Is there a way in which you can schedule an email to be sent from this file that emails the contents of cell P82 at a specific time of the day?
I have read many options using Task Scheduler in conjunction with Batch files but I am novice at best at this set up.
Any advice would be appreciated
J
Ops-Performance-Tracker.xlsm
I have a basic performance monitoring sheet that calculates an average percentage based on tasks completed in cell P82
I have used VBA on other files that creates an email from a section of the sheet or by attaching the sheet itself.
Is there a way in which you can schedule an email to be sent from this file that emails the contents of cell P82 at a specific time of the day?
I have read many options using Task Scheduler in conjunction with Batch files but I am novice at best at this set up.
Any advice would be appreciated
J
Ops-Performance-Tracker.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No problem, as always lots of ways of doing the same thing!
ASKER
You have given me two amazing options - thank you for your time and much appreciated as always
J