Sending Email Notification

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mel via AccessMonster.com
    #1

    Sending Email Notification

    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.c om
    http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1


    Tags: None
    • Roger
      #2
      Re: Sending Email Notification

      On Jun 14, 6:16 pm, "Mel via AccessMonster.c om" <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.c omhttp://www.accessmonst er.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

        Comment

        Previous template Next
        Working...