Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Lotus Notes with Excel Macro Steve Excel Discussion (Misc queries) 3 April 2nd 09 04:45 PM
Send Lotus Notes Mail with excel carloshernandezy Excel Programming 2 January 29th 06 11:01 PM
Sending e-mail with Lotus Notes pressing an excel button AndyOne Excel Discussion (Misc queries) 0 June 1st 05 09:29 PM
Sending Excel file as attachment to Lotus Notes mail Simon Lenn Excel Programming 2 December 9th 03 07:47 PM
Unable to CC more than one recipient when sending a Lotus Notes mail from Excel Dion McKnight Excel Programming 0 December 4th 03 12:39 PM


All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"