Sending Email Notification

[Database Administrator]

I have four people on my email list. I want to send one email each of the
four people with a list of accounts over due, embodied within the email. So,
for instance, jeff will be sent an email that shows in the body of the email
all of his accounts that are over due:

account #1 ABC Inc
past due on 3/12/2008

Account #2 DEF inc
past due on 4/1/2008

Account #3 GHI inc
past due on 5/12/2008


The list above would be embodied within the email. So, instead of sending
Jeff 3-emails, he would just get one email with the list of accounts that are
over due.

I'm not sure how to code this or set this up. I'm sure I need to set up a
query that will gather the accounts that are past due. But how do I get the
info from the query into the body of the email using the sendobject?

Thanks,
Mel

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

[Database Administrator]

On Jun 14, 6:16*pm, "Mel via AccessMonster.com" wrote:
> I have four people on my email list. *I want to send one email each of the
> four people with a list of accounts over due, embodied within the email. *So,
> for instance, jeff will be sent an email that shows in the body of the email
> all of his accounts that are over due:
>
> account #1 ABC Inc
> past due on 3/12/2008
>
> Account #2 DEF inc
> past due on 4/1/2008
>
> Account #3 GHI inc
> past due on 5/12/2008
>
> The list above would be embodied within the email. *So, instead of sending
> Jeff 3-emails, he would just get one email with the list of accounts that are
> over due.
>
> I'm not sure how to code this or set this up. *I'm sure I need to set upa
> query that will gather the accounts that are past due. *But how do I getthe
> info from the query into the body of the email using the sendobject?
>
> Thanks,
> Mel
>
> --
> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2008...

probably the easiest would be to create a report with the account
information
and use sendobject to send the 'report'

or use vba to fill in the 'messagetext' parameter of sendobject with
the account information