Send 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

 

[Tony Toews [MVP]]

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?

You will need to use VBA code to run through a recordset based on that
query http://www.granite.ab.ca/access/email/recordsetloop.htm

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.htm.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Mel via AccessMonster.com]

I'll read it and give it a try. Thanks!

You will need to use VBA code to run through a recordset based on that
query http://www.granite.ab.ca/access/email/recordsetloop.htm

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.htm.

Tony