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

"Kathy" wrote in message
...
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?