Having a task list due on every user. Would like to send a reminder email to the respective users about their pending item and summary with a click of a button instead of sending one by one. Is this possible to achieve? kindly assist.
Thank you. I will try it.Oops!
Link to Gina is in this Blog:-
Generate Multiple Reports - Nifty Access
Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...www.niftyaccess.com
Plus more stuff you may find helpful...
Looked at this; seems more advanced level for me.Oops!
Link to Gina is in this Blog:-
Generate Multiple Reports - Nifty Access
Generate Multiple Reports This blog came about because of an answer I gave to a particular OP's question. Therefore the code isn't generic, it is designed for a specific situation, like most examples! However I hope there's enough information here for you to follow what's happening. Multiple...www.niftyaccess.com
Plus more stuff you may find helpful...
ID | Task | User | Due Date |
1 | collect money | jack | 15-06-2020 |
2 | pay the bill | jack | 01-08-2020 |
3 | book tickets | mark | 01-07-2020 |
4 | pick up some items | lucy | 01-07-2020 |
5 | service the car | steve | 01-08-2020 |
6 | renew the lease | lucy | 01-08-2020 |
seems more advanced level for me.
Could you please advise at least how to send an email for each record? sorry I am too naive in executing the wonderful ideas proposed.Well the easiest way would be to send an email for each record?
The tidiest way IMO would be to send one email for ALL the items for a particular destination?
For that you need to sort in the correct order and then only send when the destination address/user changes.?
Here is something I used in one of my DBs.
Probably more than you need as I used html emails, but it should get you started.?
OK, could not paste, complains about more than 10K characters.
Attach method seems to have changed as well (not for the better BTW )
Also look at https://www.youtube.com/results?search_query=send+emails+with+attachments+from+access+database
Look at the code I supplied. That is pretty much doing that, just with the added complication of checking if it is the same client.Could you please advise at least how to send an email for each record? sorry I am too naive in executing the wonderful ideas proposed.