send to mail recipient

[libby]

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?

 

[Dave Ferris]

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]

Thanks Dave,

It sounds though it would be complicated as there are
hundreds of user profiles.
Is there anyway of detecting if Lotus Notes is open and
disabling the Send button accordingly?

Thanks

 

[Bigwheel]

I have found a way to copy the notes.ini file to the notes directory using
the FileCopy statement (FileCopy source, destination) and it is possible to
determine who is using Excel with Application.UserName.

For W2K or XP it would look something like:-

Sourcefile = "c:\documents and settings\" & Application.UserName & "\rest of
the path\notes.ini"
destinationfile = "c:\program files\lotus\notes\notes.ini"
FileCopy Sourcefile, destinationfile
runthis = Shell("c:\program files\lotus\notes\notes.exe")

You may want to delete the new copy of the .ini file when you close Excel as
it may cause problems with normal operation of notes

 

[Guest]

Libby - If you have found a solution to this I have a similar issue - I would
LOVE to be able to send a note to a user or a group or users via a macro in
excel - I do not have notes on the PC at this time, but I can put it on - can
you send me a copy of what you did to get the note sent - if this is infact
what you did
What my goal is -
If a particular macro gets run, due to errors in the data input - it would
automatically send and email to a group via Lotus Notes
If you can help THANKS A BUNCH

Kathy

 

[KL]

Kathy,

Have a look - maybe these would give you a direction:
http://www.forumtopics.com/busobj/viewtopic.php?t=26805
http://www.mrexcel.com/archive/VBA/28119.html


KL