Send an email 7 days before.

[Danden]

Hello,
how can I make that my access send an email to a user if there 7 days until en employee’s birthday.
Can anyone help me with this one? Perhaps there is someone who already har an example.

 

[pr2-eugin]

Few Questions to Ponder over..

1. Will there be only one Employee celebrating their birthday on that particular birthday?

2. If No, Do you wish to send out individual employees email that it will be their birthday?

3. If No, Do you wish to list all names of employees celebrating their birthday in 7 days to a PA and they will do something with that?

4. How good are you with VBA?

5. Have you looked at DoCmd.SendObject method, Working with Recordsets?

 

[Danden]

Yes, it is point 3. I would like to list up all employers that have a birthday in 7 days and send an email to a particular person(the boss) about it.
I am not an expert in vba but I think I can find it out with some helps.

 

[pr2-eugin]

Okay in the Past, I helped another user with quiet the similar request.. You might be able get some Idea of what to do.

If you do not follow something post back I will do my best to help you out.

 

[Danden]

Thanks for your input pr2-eugin. I've created a macro that finds workeers who have a birthdays in seven days and with help of AutoExec sends automatically a mail once a week.
But because I do not know how often the application will be opened, I want to know how can I start the macro by using the Windows scheduler? I have no experience with batch filer?

 

[pr2-eugin]

I have never used Windows Scheduler so far.. So I am not entirely sure how to guide you down that path, but I am pretty sure that someone on this Forum will have the information on that. I would just start with Googling for the issue.