View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Ferris Dave Ferris is offline
external usenet poster
 
Posts: 1
Default send to mail recipient

Lotus Notes depends on being able to find notes.ini One way to help would
be to copy the notes.ini file into the directory that notes.exe is stored.
For multiple profiles however, this may not be practical. Windows achieves
this by using shortcuts where you can specify the target (c:\program
files\notes\notes.exe) and a start-in directory ( path to where notes.ini is
stored. ) I don't know if there is a way of simulating this in Excel.

"libby" wrote in message
...
Hi

I have a spreadsheet with a button on it that calls a
macro which is the same as File\Send To\Mail Recipient

Until recently we've been using Microsoft Outlook which
was fine, but now we're using Lotus Notes.

Lotus notes requires a password whereas Outlook was happy
with just the NT logon.

If the user has Lotus Notes open then there isn't a
problem.

I use the Shell(path) to open notes but it says it can't
find a .ini file which is linked to the users NT profile.

When I try and open Lotus notes using Shell(path) it says
it can't find this .ini file.

any ideas anyone?