Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009

    Unanswered: Automatic Email of report through Access

    I am a novice in Access and use the 2003 version. I am unable to write code.

    I have developed a database that has a date field ("Expiry Date") and would like Access to automatically generate an email report in lotus notes if the current date is 90 days prior to the expiry date.

    Can anyone advise me how best this can this be achieved?

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    You'll most likely need to find some vba code for MSAccess that generates emails for lotus notes. It may be simple code or it could be complex which involves dll's and other controls. If you had outlook installed on the server your mdb resides, you could use outlook commands (ie. vba).
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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