Advertisement

07.10.2008 at 09:57AM PDT, ID: 23554520
[x]
Attachment Details

Need help creating a list of email addresses to send to outlook

Asked by snyperj in Microsoft Access Database

Hi- please see screenshot below and sample db attachement.  This is a sample of something very similary I need to do in our bigger app.

When the command button is clicked, I would like to create a string of the remaining email addresses and place it in the textbox.  It will later be used for a send mail statment to send a single email to a chosen list.  Can someone help with the code for the command button to create the email list?

For example- in the screenshot, when the command button is clicked- the following string would be dropped in the textbox.

george.pool@frontway.com;Abrown@wiltop.org;crystal@hotmail.com

(note the semi colon spacer for Outlook)

Thanks for any helpStart Free Trial
Attachments:
 
db sample
 
 
Screen Shot
Screen Shot
 
[+][-]07.10.2008 at 10:16AM PDT, ID: 21975591

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.10.2008 at 10:21AM PDT, ID: 21975631

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.10.2008 at 10:51AM PDT, ID: 21975880

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Sign Up Now!
Solution Provided By: irudyk
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.10.2008 at 11:06AM PDT, ID: 21975982

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628