Hello UA,

Can someone please guide me through:

1. I have a form (Entry Form) and one control is an "Email Address", how can I make the textbox control to receive more than one entry (email addresses).

2. How to make a list box of emails, after selecting the email, I have a button (Add) to click and the selected item will copied to my "Email Address" control above.

Appreciate any help please.

Many thanks
rj

NOTE: My form is a bound form..

Edited by: ksalearnsaccess on Thu May 21 12:24:03 EDT 2009.

You do not want to put more than one email address into a field in a table. If someone has multiple email addresses then create a related table and save each email as a RECORD in that related table.

As for your second question - You could use a Multi-Select list box then used code to add the selected emails to the table I mentioned above....

hth,
Jack

Hi Jack,

Thanks for picking my post very quick.

No, my recipient will have only one email ad, but sometime, it will be more than one recipient.

On your second statement, I can only built listbox using the wizard, how can I built a multiselect listbox, and what would be the Adding Code into my email address textbox.

Question, is textbox capable of receiving multing entries? that would be separated with semi-colon ((IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) ?

Thanks again Jack,
rj

rj -

Do not save more than one 'recipient' in a field in a table. If you need a string of recipients then build it as needed, but do not save multiple pieces of data in a field in a table.

A text box is capable of holding more than one recipient, but the text box should be unbound so that data is not saved to your table.

You can create your list box using the Wizard and then you can change the Multi Select property to Simple.

This code will concatenate the selected items in the list box:



The code assumes that email address is in the first column of the list box...

hth,
Jack

Hi Jack,

I will try to change my "Email Recipient" into unbound control. I'm afraid if my SEND button code will still work, but let me try it in my office tomorrow.

Does the code u gave copy the selected email into my recipient control? Suppose I will put the code on "OnClick Event of my Add button?.

Many thanks Jack,
rj

rj -

The code puts the list of emails into a string called 'strList' and it can put it in your 'recipient control' as well. If this code is on the same form as your button to send emails then you can put strList as the variable for the 'email recipient' part of your code to send emails...

The code would gon in the On Click event of a button that you click after you make your selection in the list box....

hth,
Jack

Hi Jack,

Sorry for stay off long.

The code you provided is worked perfect, thanks a lot Jack.

Minor touch up Jack, if you can spare minute with me.

I tried to clear my recipient email (unbound text) on the click of my NEW button but it didn't cleared up by the following code:

Me.recipient_email = ""

What is wrong with this code.

Thans in advance Jack,
rj

Hi Jack,

Just a small clarification regarding your;

----
The code assumes that email address is in the first column of the list box...
----

Jack how can I make that the code will get the value in the second column of my list box?

I want to list first the name then the email address.

thanks again,
rj

rj -

The code works for me. I would rename the control RecepientEmail (no space) and then try your code. This should work as well:

Me.ReccepientEmail = Null

Good Luck!

Jack

rj -



This should do the trick. Remember that list boxes are zero based so the second column is column 1

hth,
Jack

Hi Jack,

Many thanks for the help, everything is worked just fine.

rj

Jack,

How can I use NZ function in my send code so that it will accept a null in CCRecipient control. I noticed that if there is no content in my CCRecipient it stop the sending.

Thanks again,
rj

I think this is what you are after:

Me.NameOfUnboundTextBox = Nz(Mid(strList, 3), "")

UNTESTED!

hth,
Jack

Thanks Jack, let me try tomorrow in my office.

I hope this will handle the null error if sending no value on CCRecipient.

Many thanks once again,
rj

rj -

I am not at all familiar with the code you are using to send emails so I do not know how a Null CCRecpient is handled and what you need to do so that if it is null the code does not error out...

Jack