Sending Email Notification

[Mel via AccessMonster.com]

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

[Roger]

On Jun 14, 6:16*pm, "Mel via AccessMonster.com" <u7122@uwewrote:

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