grouping items to email

[Guest]

I need to be able to email daily notifications to users, possibly having only
1 entry per addressee, or maybe many. I have a working module that can send
emails using SendObj (Access/Outlook 2003), now the next step is to either
combine multiple rows returned from the query somehow, so that only one email
is sent to each addressee (with multiple lines with info from each row
'hit'), or devise a multi-step process to identify the addresses that need an
email daily, and then run the appropriate report to include as a unique
attachment to the one email for that addressee daily.
This is an existing 'schedule' Access database that probably could be
better done now in Outlook, but due to time/company constraints, must use
what is at hand, in the time allotted, with no further expenditure of funds
(no 3rd-party software).
Are there any suggestions as to the best approach? I can use what I
have, but the users might get 20-30 emails in a day, each one I'm still
having to click 'Yes' for, to get past the Outlook Security box. Thanks in
Advance, Eldon

 

[Ron2005]

Some for thought:

1) create a summary/distinct query that just gives you the name or
whatever of those who are to get email
2) Create a query that restricted to just one person at a time giving
you all the data you need to send them.

Then in the module create a function to:

bounce through the first query formating part of the email
setup the second query constrained by key from first query
now bounce through second query adding all of the
pertinent info to the body of the
email body = body + newdata (with carrage returns)
at eof
send the email
at eof
end the routine.

 

[Guest]

Thanks. I sort of had come to that comclusion. I will pound at this one for
a while, and may come back for more help if I get stumped. The mechanics of
this aren't hard, its the getting the pieces working together that still
gives me trouble. VB has proven more cryptic than I had hoped.

Thanks again, Eldon