I can get a report to print itself on one specific day using


If (WeekDay(Now()) = 7) And (Time >= #7:00:00 AM# And Time <= #7:31:00 AM#) Then
DoCmd.OpenReport "myReportName"
End If

But

I need a report each morning Monday through Friday. How do I get it to print every weekday?

Help would be greatly appreciated