Select Email Adress using Check Box

[DavidG]

Hi all,

I am currently configuring a form in Access 2003 and have hit a dead end. I
require users to be able to select multiple e-mail adresses using a check box
and then export them into the "To:" adress bar in a new Microsoft Outlook
e-mail message using controls (i.e. check box, export button), found on the
form.

I have already configured a simple "on-click" event in which users simply
click on the email adress they want to mail to, but this only works for one
email adress at a time and opens a new message for each adress selected. In
order to use this form more effectively it is necessary to slect multiple
adresses to save time cutting and pasting into the adress bar.

Any help would be greatly appreciated.

Thanks,

David.

 

[orange]

Hi all,

I am currently configuring a form in Access 2003 and have hit a dead end. I
require users to be able to select multiple e-mail adresses using a check box
and then export them into the "To:" adress bar in a new Microsoft Outlook
e-mail message using controls (i.e. check box, export button), found on the
form.

I have already configured a simple "on-click" event in which users simply
click on the email adress they want to mail to, but this only works for one
email adress at a time and opens a new message for each adress selected. In
order to use this form more effectively it is necessary to slect multiple
adresses to save time cutting and pasting into the adress bar.

Any help would be greatly appreciated.

Thanks,

David.

Just a thought -- could you use a button on the form to simply add the recipient name to a variable, then add another recipient etc, until you have 5- 10 whatever number of recipients in a string. Then click your current button to send the email where the button click would move the string variable containing the recipients to the To area, then send the email.

Would require a little logic change and a button or event to append recipients to the string variable...
but it might simplify the whole process.

 

[Paul Shapiro]

You can either use individual checkboxes for each email address, or a
listbox that allows multiple selection. The command button to create the
email has to be a level above the individual email addresses. If the emails
are each a row in a form, make that form a subform and put the command
button on a parent form. If the emails are in a listbox, the command button
can be on the same form that contains the listbox.

 

[DavidG]

Hi thanks for the reply Paul. I would be using the individual checkbox
option. The email adresses are each a row in the form (up to around 15 rows
for each record) and the form has multiple records. I have also converted
this form into a sub-form so that my command button will be a level higher
than the checkbox control but i am still unsure as to how to configure both
the check boxes and the command button. I am relatively new to access and
dont have much of a grasp on the coding techniques used and the wizards are
not much help for this particular application. Any guidance to get me started
would very much be appreciated.