Hey Everyone,
I have a continuous form with a combobox called 'Groups' in the header. It has a number of text boxes on the detail section of the form. From the combobox the user can choose from 'Foreman', 'Worker', Ex-Worker' and 'Client. Depending on what is chosen in the combobox, the textboxes are populated.
One of the textboxes is called 'Email', if the user chooses 'Foreman' from the combobox, it populates the list with 20 different email addresses.
What I would like to do is have a command button when clicked will take all the email addresses related to 'Foreman' and make an instance of outlook containing all the relevant addresses to send a group email? How can I go about doing this.
Thanks,
Nim
I have a continuous form with a combobox called 'Groups' in the header. It has a number of text boxes on the detail section of the form. From the combobox the user can choose from 'Foreman', 'Worker', Ex-Worker' and 'Client. Depending on what is chosen in the combobox, the textboxes are populated.
One of the textboxes is called 'Email', if the user chooses 'Foreman' from the combobox, it populates the list with 20 different email addresses.
What I would like to do is have a command button when clicked will take all the email addresses related to 'Foreman' and make an instance of outlook containing all the relevant addresses to send a group email? How can I go about doing this.
Thanks,
Nim