 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / June 2006Help on Emailing to a Group
Hi, I am trying to work on an employee database. The tables and fields that I am working on are listed below. I created a query because I wanted to separate the employees by department (selected query). The fields below are the ones I needed for the query. Then I created a form based on the query I created so that I can make use of a button that will prompt an event. That event will open Outlook and enter the emails from the form in the “To:” field. I am not sure if I still need to make a query since I can get the same info (and get the employees divided into departments) by going directly into making a form. Hope this helps. Thank you again. I really hope I can get this working. Table: Departments Field: Department_Name Table: Personal Fields: Last Name, First Name Table: Work Field: Email Query: Management_Query Form: Management_Form Access DB 101 Tables contain your data. Queries are like wearing glasses. Sun glasses filter out some types/colors of the light. Queries allow you to be selective in what you see, allow you to combine tables so that you see the information grouped etc.for your use. Forms are presentation tools. They allow you to present information in a pleasing manner. But the question is what to forms present. They have to have a "Record Sourse" They have to get the data from something. They can get the data either from a table or a query. What I am saying is that what you have really described above are three tables, a Query, AND a form that if it is showing any data is based on a Query. If you go to the record source of your form, I am willing to be that you will see "SELECT......" etc. Then if you go to the Query you have defined and open it in design view and right click to see it in SQL view you will see "SELECT ..." etc. In the form if you mouse the .... box and it opens a query wizard you can also then press the save button and can save that as a query. The end result is you have 3 tables, two queries and a form that is using one of those queries. The answer then is you need the form to present the data and perform the selected actions. You also need the query that the form is based on wether it is saved as a query or simply is composed of a SELECT statement in the record source. You obviously need the tables. Now if the record souce of the form IS the query called "Management_Query" then you will need it otherwise the form will NOT have any data to show. Thank you. Based on your reply, what i want to do next is create a button on my Form (record source is the mentioned query). What I want the button to do is open up MS Outlook and enter the email information from the Form into the "To:" field of Outlook. I hope that the names of the Tables and Fields will be enough to help you help me on my problem. Thank you. >Access DB 101 > [quoted text clipped - 31 lines] >"Management_Query" then you will need it otherwise the form will NOT >have any data to show. > Thank you. > [quoted text clipped - 3 lines] > field of Outlook. I hope that the names of the Tables and Fields will be > enough to help you help me on my problem. Thank you. Look up Outlook+automation in this NG. I think Danny Lesandrini has a simple example on his website... http://www.amazecreations.com/datafast/CodePages/CodeOutlookMail.asp then if you have a series of e-mail addresses, you can just add them one at a time to the Recipients collection. do until rsEMail.EOF olkMsg.Recipients.Add rsEMail.Fields("Address") rsEMail.MoveNext Loop that help? Thank you for your effort in helping me out. I am a newbie in MS Access and I just have to ask, where i need to paste the sample code? is it going to be for the button? Thank you so much. >> Thank you. >> [quoted text clipped - 16 lines] > >that help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.