Help on Emailing to a Group

[BernardNem via AccessMonster.com]

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

[Ron2006]

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.

[BernardNem via AccessMonster.com]

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:

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.

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

[pietlinden]

BernardNem via AccessMonster.com wrote:

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.

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?

[BernardNem via AccessMonster.com]

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.

pi********@hotmail.com wrote:

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/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?

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