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/Forums.aspx/databases-ms-access/200806/1
