I administer a recognition database that we use at work that allows employees to send "Thank You" emails to employees who have helped them with various work related issues. I created a form Called Frm PennyThought. The submitter will complete the following fields on the form (submittername,recipient,manager,etc.). I have a button on the form and I have a send object macro attached to the button, that "on click", an email is sent to the recipient. An attachment of a certificate is also included in the email.
The issue I am having is that the form only allows one recipient. I have been asked to allow the form to be sent to multiple recipients. The recipient field on FrmPennyThoughts is a combobox that is linked to a table called TblName, which lists all of the employees in my division.
I could just create multiple recipient fields on the form, but I would prefer not to go that route. I would like the user to be able to choose names from the recipient field and then have that name append to another field on the same form. In doing this, the user would be able to choose as many names from the list as they would like and have all of the names append to 1 field on the form. I tried using the sertvalue macro, but everytime I chose another name, it replaced the name in the field that the alue appeneded to. I DO NOT want the field to be replaced with a new value or go to a new record until I click the send button at the bottom of the form.
Can someone help me with this.