Queue, Check and Approve Emails

1. Run Build Email Queue

In Power Automate, go to My flows, hover over Build Email Queue, click ▷ Run, and enter the Enriched File’s exact file name.

Run it only once per course file. Running it again adds a second full set of emails for every learner — there’s no duplicate check.

2. Review the queue

Open the master workbook, go to the EmailQueue tab, and filter Status to Pending Review. Then check the SanityCheck column:

• OK — nothing obviously wrong.
• Missing data — something in the Enriched File is blank. Fix it before approving.
• SendDate in past — usually a session date was entered wrong. Check it before approving.

Delete any rows that shouldn’t go out.

3. Approve

Change Status to Approved for every correct row, and don’t touch SendDate or SentDateTime.

Tip: select several Status cells, type Approved, and press Ctrl+Enter to fill them all at once.

4. Let Daily Sender do the rest

Each day it sends Approved rows that are due today or earlier, and marks them Sent or Failed.

Same-day sends: if you approve a course after that day’s 07:00 UTC run, its Enrolment email goes the next morning. If Women’s Aid needs login details the same day, run Daily Sender manually (▷ Run) after approving.