Help 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

--
Message posted via http://www.accessmonster.com

re: Help on Emailing to a Group

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.

re: Help on Emailing to a Group

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.

Ron2006 wrote:[color=blue]
>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.[/color]

--
Message posted via http://www.accessmonster.com

re: Help on Emailing to a Group

BernardNem via AccessMonster.com wrote:[color=blue]
> 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.[/color]

Look up Outlook+automation in this NG. I think Danny Lesandrini has a
simple example on his website...

http://www.amazecreations.com/datafa...utlookMail.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?

re: Help on Emailing to a Group

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.

pietlinden@hotmail.com wrote:[color=blue][color=green]
>> Thank you.
>>[/color]
>[quoted text clipped - 3 lines][color=green]
>> 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.[/color]
>
>Look up Outlook+automation in this NG. I think Danny Lesandrini has a
>simple example on his website...
>
>http://www.amazecreations.com/datafa...utlookMail.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?[/color]

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1