SteveBradshaw
New member
- Local time
- Today, 19:24
- Joined
- May 12, 2020
- Messages
- 4
I have designed an Access Database that works out commissions and Overrides for about 400 Advisers. We run this every 2 weeks for a commission run.
At the end of each commission run statements are sent out from the database to each Adviser from the Access database. At present they are sent out one at a time.
To do this there is a form with a combo box whereby the Adviser is chosen and this then searches the chosen Adviser on the form and a filter by selection occurs, a statement pdf is created and an email with the pdf attached is created. This is then sent and we go back to the form, choose the next adviser and repeat the process.
I am trying to work out how to send them all in one go? Any ideas?
At the end of each commission run statements are sent out from the database to each Adviser from the Access database. At present they are sent out one at a time.
To do this there is a form with a combo box whereby the Adviser is chosen and this then searches the chosen Adviser on the form and a filter by selection occurs, a statement pdf is created and an email with the pdf attached is created. This is then sent and we go back to the form, choose the next adviser and repeat the process.
I am trying to work out how to send them all in one go? Any ideas?