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


"libby" wrote:

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?