Select Email Adress using Check Box

D

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.
 
P

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.
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top