Sending email through Outlook by a Certain Date

[tschmid]

I am a College Instructor and I would like to make a Database that will regularly email me a list of Students who are approaching the mid-point of their Program.

Is it possible to program Access to email a list with Student Names, Registration Numbers, etc, etc. by a given date?

As of right now I have a Database with all of the students' pertinent information but I have to manually comb through the Database each week to see which students will require a Mid-Term interview that week.

Thanks for any advice you can offer!

 

[Cronk]

I don't see why you necessarily want the list in an email. Why not run a query to extract the list to display it on screen and/or print.

 

[tschmid]

I was thinking email so that I could forward it to colleagues, but your suggestion would work as well since I could just distribute printed copies. Thanks for the suggestion.

 

[pr2-eugin]

[FONT=&quot]Think Green! Do you need to print this?

[/FONT][FONT=&quot]Email would be a much better suggestion, Run the Query and use DoCmd.SendObject to send email..
[/FONT]

 

[willknapp]

Another option would be to create an outlook task that will do this for you automatically at whatever specified interval you choose - I'm guessing weekly. You can create the query in your access database, and then have the outlook task run an Outlook VBA procedure that connects to the database, runs the query and then does the emailing for you.

 

[tschmid]

thanks willknapp. I'm all about saving paper. I'm not a programmer and I am very new to Access so I don't think I had the proper vocabulary to describe what I wanted to accomplish. I think I'll do some more research on creating queries and VBA procedures.

 

[willknapp]

Another option would be to create a macro that accomplishes your task. That would at least save you a few steps, and shouldn't require much, if any, advanced VBA coding. You'll want to us the SendObject action that pr2_eugin refenced. Good luck!

 

[tschmid]

that's great! thanks so much!