result of many queries send by email

[Avir]

Dear All,

We have a small order management database.

This database is used by 10 people. Some of them are sales rep and some are
their support staff. We wish to make an automatic alert system which will
generate alerts to the users informing then what work is over due in a
particular order.

For example, within 2 days of booking the order, the user is supposed to
print sales note and fax it to customer. Also within 7 days of booking the
order a PO should be printed and faxed to supplier.

We wish to send such reminders to users (every user should receive
information of their respective orders only) via ONE email per day.

Since we have limited knowledge, could you please guide us how to make this
happen.

We have successfully made email alert system but it is good only for ONE
query.

Is it possible that we have multiple queries running automatically at one
specified time; the result of which will be stored in one table. A macro will
send one EMAIL to each user informing them all that should be done for their
orders.

Any clue would be highly appreciated.

Many thanks!

 

[Steve Schapel]

Avir,

The general sort of model you could consider here would be to make a
table for the relevant information about the overdue processes. Then,
each of your queries for the different processes could be an Append
Query to add the overdue information to the table. Your code will
delete all the data from this table first, and then run all the appends
to put all the current overdues into the table, and then use the table
as the basis of what gets sent in the email. Hope that helps.

 

[Avir]

Dear Steve,

You bet it helped! Many thanks for your detailed and accurate reply.

regards
Avir