Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    automatically send a email

    Can you automatically send a email from microsoft access to outlook on the 1st of every month? We keep our birthday list in access and would like the list of everyone having a birthday that month to be emailed. The report only pulls that current month birthdays. If so how?

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 984 Times in 914 Posts
    When you say "automatically" do you mean run the report on it's own, or send an email when you run the report?

    Either way you can send email various ways, either by calling Outlook or another email program like Blat from a report.

    cheers, Paul

  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would like it to run a report on it's own. I'm using access 2003. How can this be done?

  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    If your database is opened every day then it could be set to send the emails the first time it is launch on a specific date.

    You could also use the task scheduler on a Computer that is always on to run open a database one a month and send the emails. If you are doing that It could run every day and send out the email on the actual day.

    FWIW, There are also web sites that can be used to handle this.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •