Send auto reminder to update a spreadsheet

[Fetchmethatgin]

Hi all,

A query if this is possible. We're using excel as task management currently. This needs to updated weekly by team members, is it possible to have excel send a weekly email reminder to update the sheet? I've done one in the past when a date was due to expire but not for when the date is coming up. For reference it would need to be updated every wednesday by the team. We do not have power automate either, our organisation is in the process of switching to 365 which im currently on.

 

[Kerryx]

Why not just use your email to send a scheduled email notification?

 

[Fetchmethatgin]

Why not just use your email to send a scheduled email notification?

That was my argument but because the team chop and change a lot for resilience it was considered to keep it in a central location

 

[Kerryx]

Think you may need something like this
Email using VBA
Create an automated task with windows scheduler