Send Calendar Events from External Applications/Email

Specifically, I would like to send a reminder, appointment, or to-do entry to a Notes account by clicking a command button on an MS-Access form.  I don't have direct access to a LotusScript compiler and we don't have full blown VB, just VBA as part of MS-Access.  On that same vein, is it possible to send non-meeting calendar events from a Notes account to a Notes account or any type of calendar entry or to-do from an external e-mail (such as Outlook or web-based)?

Who is Participating?
qwaleteeConnect With a Mentor Commented:
I actually wrote this up some time ago, see

The Notes client has to be ***installed,*** but VBA be the one driving, not Notes.

Some insights on calendar entry structure at -- -- this uses LotusScript, but principles are identical.

Bradley_McDonaldAuthor Commented:
Thanks for getting back so quickly.

I'm getting a hangup on...

Set db = s.getDatabase ("","")

... it wants a database name to be provided

I presume that the getDatabase command is similar to getObject and is looking for the parameters "pathname", "and/or class"

I'm not sure what to enter for either (is it looking for an .nsf file?) or why in my case it hangs up on this line.  I don't know either VB or how Notes is structured well, so I have no idea if this is a simple issue or not.
madheeswarConnect With a Mentor Commented:
Set db = s.getDatabase ("mentionservername","MentionDatabaseName.nsf")
It should work.  Note the last sentence from the help text below:

Set notesDatabase = notesSession.GetDatabase( server$, dbfile$ [, createonfail ] )
String. The name of the server on which the database resides. Use an empty string ("") to indicate a database on the current computer: if the script runs on the workstation, the empty string indicates a local database; if the script runs on a server, it indicates a database on that server.
String. The file name and location of the database within the Notes data directory. Use empty strings for both dbfile$ and server$ if you want to open the database later. Use a full path name if the database is not within the Notes data directory.
Norally, getDatabase takes a server and path as parameters, and opens that database.  Here, we want an UNOPENED DATABASE OBJECT, not assigned to a specific server or file, so that we can use the openMailDB method on it.  There are a few other ways to handle that.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.