Bradley_McDonald
asked on
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)?
Thanks!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It should work. Note the last sentence from the help text below:
Syntax
Set notesDatabase = notesSession.GetDatabase( server$, dbfile$ [, createonfail ] )
Parameters
server$
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.
dbfile$
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.
Syntax
Set notesDatabase = notesSession.GetDatabase( server$, dbfile$ [, createonfail ] )
Parameters
server$
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.
dbfile$
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.
ASKER
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.