Ravi Kumar
Registered User.
- Local time
- Today, 10:26
- Joined
- Aug 22, 2019
- Messages
- 162
Dear all ,
I have a table(name:Tasks) which has 4 columns:
1. Date
2. Task
3. Status(pending/completed)
4. Responsible person(email link)
I need to send a mail to everyone only once per week if the task is pending.(Mondays to be precise)
Currently I am using a report which filters only pending & then I am sending the mail using docmd object.
Does anyone has a vba code to automate this through a button which I can place in my main menu form?
I have a table(name:Tasks) which has 4 columns:
1. Date
2. Task
3. Status(pending/completed)
4. Responsible person(email link)
I need to send a mail to everyone only once per week if the task is pending.(Mondays to be precise)
Currently I am using a report which filters only pending & then I am sending the mail using docmd object.
Does anyone has a vba code to automate this through a button which I can place in my main menu form?