By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,009 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Create e-mail lists from query

P: 1
Overview: I have a form screen where users input criteria into different text boxes to limit a contact table. This is then fed into a query that limits the list returned. The returned list is in a datasheet subform placed on a form (to keep it professional looking). From here they can double click the name to open up another form that displays more info on that contact table or close it to reset the search.

Problem: I want to add like a checkbox to the returned list that the user could check and then press a command button that will spawn an outlook message and pass all the email addresses associated with the contacts that are checked into the cc line.

I would say I am an experienced user with access, pretty fair with VB and C /x. I know how I would approach this problem with a pure VB or visual C application but unsure of the approach in MS Access. Should it be a query-based? If so, how do I use the cmdSendEmail to package it all up? (I can use it for individual purposes). Should I create a temporary matrix to perform the look-up and data presentation? I just have to believe that I am not reinventing the wheel if someone has an easier idea. All suggestions are greatly appreciated. Thanks.
Aug 11 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,

You can use docmd.sendobject command to send mails...

To accomplish your task you need:

1. A function Send_email( options for docmd.sendobject)
2. An update query that changes the flag before your contact in the query to false. In the update query you use the function send_email()
After the execution of the query your mails will be sent!
Sep 6 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.