displaying multiple email addresses

[kaygirl]

I have a table with around 300 contacts, each contact has an email address.I have 8 working groups that i would like to email news and events to. I was wanting to design a form with a drop down list of the 8 working groups or 8 seperate command buttons that when each group is selected it displays that groups email addresses in a text field eg.
member1@yahoo.com,member2@yahoo.com,etc
so i can then send one email to the whole group.I would appreciate any help with how i can display the email addresses in a text field one after the other seperated by commas.Thanks in advance.

 

[quatermass]

Hi,

On the form, have combo boxes for the addresses and check boxes for the addresses you want, a button to generate the string and a text box to display the combined address list. This output could then be copied and pasted into youe email address list.

If you have a temporary string set up on a 'generate email' button, combined with check boxes for each of the required email addresses. This would allow you to do something like:

if checkboxN = -1 then
if emailAddress <>&quot;&quot; then
if strtemp = &quot;&quot; then
strtemp = emailAddress
else
strtemp = strtemp & &quot;,&quot; & emailAddress
end if
end if
end if

The final task of the button would be to display 'strtemp'.

You can add in as many if..then..elses as you have email addresses. If you are always going to have the first combo box filled, then you will not need the check for empty string, as 'strtemp' will always be filled in order, you will just need the check for an empty list item.


Hope this is of help,

Kevin **************************************************************
The difference between fiction and reality is that fiction has to make sense.
**************************************************************

 

[kaygirl]

what i was hoping to do, if i can was to use my working groups table to display all the email addresses for people in that group, then with all the email addresses displayed in a text box to press a command button to send the email.
The working group members change frequently so i was wanting to get the updated email addresses from the table without having to preselect and cut and paste into my outlook address book.Is their a way i can do this...thanks.

 

[kaygirl]

I think i could do this by using the results from a query to display the emails in a listbox but i am unsure how to seperate my reults in the list box by commas so that i can use it as a multiple Email....