By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,750 Members | 1,456 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,750 IT Pros & Developers. It's quick & easy.

Sending Email Notification

P: n/a
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

Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.