Email from Access Query

[Guest]

I work in a bank and have built a database designed in Access 97 that tracks loans from approval to funding and then reciept of documentation.

I have created a query to return loans not drawn after 3 months .

What I would like to be able to do is to generate individual emails for each record in the query to branches to follow up funding of these loans in the query.

keeping in mind that not many people in the organisation I work in are very computer literate, what would be a suggestion of the easiest way to generate an email for each record in this query??

The Banks email network recognises the Branch number as a legitimate email recipient and how can I put that field from the query in the "To"box of the email??

Emails must also be less than 100K.

Any help, advice and/or suggestions would be greatly appreciated.

 

[Arvin Meyer]

Here's some code that should do the job for you:

http://www.datastrat.com/Code/MultipleEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I work in a bank and have built a database designed in Access 97 that

tracks loans from approval to funding and then reciept of documentation.

I have created a query to return loans not drawn after 3 months .

What I would like to be able to do is to generate individual emails for

each record in the query to branches to follow up funding of these loans in
the query.

keeping in mind that not many people in the organisation I work in are

very computer literate, what would be a suggestion of the easiest way to
generate an email for each record in this query??

The Banks email network recognises the Branch number as a legitimate

email recipient and how can I put that field from the query in the "To"box
of the email??

 

[Byron]

You cannot just send an email or for that matter do much
of anything else with just the query.

However,just as an overview, you could use your query as
the record source for a list box in a form. Then either
process each record after it is selected in the list box,
or if you just what to send the notice to each branch
about their loans, you would need to be able to sort the
list for only those for one branch. Then use code in the
OnClick event of a button on the form to do the actual
sending of the email.

There are multiple ways of dealing with the information
that you would need to send with the email. First, would
you also want to send the notice to perhaps a different
loan officer at each of the different branches? If so,
then even more processing of the information would be
requires. Would you then wand to send only selected
pieces of information that you would add to the body of
the email or are you wanting to send the record from your
database as an attachment of some sort to the email?

As you can see, the creation of one query, although it
produces the information you were looking for, may not be
all that you would need to complete the task that you
have in mind.

HTH

Byron

-----Original Message-----
I work in a bank and have built a database designed in

Access 97 that tracks loans from approval to funding and
then reciept of documentation.

I have created a query to return loans not drawn after 3 months .

What I would like to be able to do is to generate

individual emails for each record in the query to
branches to follow up funding of these loans in the query.

keeping in mind that not many people in the organisation

I work in are very computer literate, what would be a
suggestion of the easiest way to generate an email for
each record in this query??

The Banks email network recognises the Branch number as

a legitimate email recipient and how can I put that field
from the query in the "To"box of the email??

 

[Guest]

Thanks Byron,

All I need to do is notify the Branch of all the loans that they have that are not drawn. It is bot directed to individual loan officers. Branch Manager will get the email then he/she will follow up.

You have given me a thought though, would it be easier to create a report separated by branch and then email that report to the branch.

Any suggestions on this??