Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Currently Open Lotus Notes Mail Server Info in Excel Macro
Hi,
First off, I'm using a macro similar to the one posted by Andy Wiggins he http://groups.google.com/group/micro...0ef8a43c0a0630 The part I need help with is this: ''Establish Connection to Mail File '' .GETDATABASE("SERVER", "FILE") Set objNotesMailFile = objNotesSession.GETDATABASE("", "") 'Open Mail objNotesMailFile.OPENMAIL I can get this code to work fine if I input my individual details in the "SERVER, FILE" section, but what I really what to be able to do is to get the macro to read the relevant information from Lotus Notes (which will already be open) and use this for the server and file information. i.e. The currently open mail server is the one used in the macro. The purpose of this is so that other people in my work can use the macro on on their own machine without having to type in their own details (many of them wouldn't know how!). I know that everyone has Lotus Notes open all the time, so was hoping that I could use this fact to find a solution! Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Lotus Notes with Excel Macro | Excel Discussion (Misc queries) | |||
Send Lotus Notes Mail with excel | Excel Programming | |||
Sending e-mail with Lotus Notes pressing an excel button | Excel Discussion (Misc queries) | |||
Sending Excel file as attachment to Lotus Notes mail | Excel Programming | |||
Unable to CC more than one recipient when sending a Lotus Notes mail from Excel | Excel Programming |