Solved

Send reminder from Access to Lotus Notes

Posted on 2008-06-17
6
805 Views
Last Modified: 2013-12-18
I have a table/form with field called CurrentDueDates and field called UserEmail with the email address, I would like to send automatic reminder to user if the currrentDueDates are within 15 days of today or are past.  
Question is, can the reminder be sent into Louts Notes programtically without user having to open Access database.
0
Comment
Question by:danrafrye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 63

Accepted Solution

by:
SysExpert earned 500 total points
ID: 21809021
If this is an email reminder, then you have a few options.

To automate the process,  you can export the table to Excel or as a CSV, and have Notes read that file instead of access, and send out the emails.

I hope this helps !
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 21809072
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 21809120
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 21809140
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question