My supervisor has asked me to make it possible so that an email will go out to him and two other people on a Monday Morning at 6am containing all infomation in a database that takes place that week. I know about the SendObject command, and I also found something through the help files about a weekday object or something. I am using Access 2003 to try and accomplish this. I have no clue how to even start getting this to work. I'm not even sure if it's possible. Please help if you know any answers.

To get the event to kick off on Mondays, you could use something like

If Day(Now()) = "Monday" Then
Run your email code
End If

To add in the 6:00 AM component, try

If Day(Now()) = "Monday" Then
If Format(Now(),"HH:MM") = "06:00" Then
Run your email code
End If
End If

It's been a while since I've needed to use that sort of thing, so I'm a bit rusty, but I think if you play with it you should be able to make something functional.

Edit: Ha! Just saw when this was originally posted, so I very much doubt the original person will read this. Hopefully, it'll help someone else.