Filling a Textbox with email ids

[gsrajan]

Please help me. I am building a form where user can send emails from the form. I have bound eTextbox (Textbox) with email ids (around 40 email ids) and bound check box (ChkEmailSelect) to select the email id in frmEmailSelect. It is a continuous form. I wish to add the check marked emails in another form (frmEmail) in a textbox (TxtTo) with ";".

Table Name: tblEmails
Email Field Name : SendTo
Checkbox Field Name: SelectToSend

Thanks for your help.

 

[jdraw]

What exactly is the purpose of the Form? What is the record source of the Form?

Normally, you would not place multiple emails in a textbox.

Are you sending custom/personalized emails to each recipient?

Have you considered, in general terms:
-A table of people with coordinates including current email address
-A table of events/conditions identifying who should receive an email.

Processing/Looping a record set of the selected individuals and sending the appropriate email?

Perhaps you could post more details about who should get what email under which condition(s).

 

[gsrajan]

I am designing an unbound form (Form1) with a text box for the emails (recipients), a text box for subject and a text box for message text. I need to fill the text box with emails from another text box which is in form ( form 2 ) which are bound with a table which has two fields. Email Ids and yes or no field.

From the unbound from the user opens the bound form with command button click ( which is a continuous form with email ids ). The user selects the email ids by check marking and close the form. When the user closes the bound form, the text box in the unbound form is filled with the emails ids the user selected.

I do not know whether I am doing correctly or not. Once the text box is filled with the emails ids, the customer types the subject and message body and send the mail with the send object method, referencing the text boxes for To, Subject and Message.

Please correct me if I am wrong. If it does not work, please let me know how to do this.

Thanks, for you help. Basically I am looking for a fancy form instead of outlook interface.


Thank you.

 

[burrina]

I think you are going about this the wrong way! You should be using a ListBox for all of the email items and then populate the text boxes accordingly. Also, you must consider whether your IP or other IP's will allow multiple email recipients on one line.
Will you be using BCC?

HTH