Hi,

Currently I have a shared excel file that is open 24 hours a day, it
records warehouse information in many forms. I am wanting to either
schedule or have a button on excel that initiates a email to be
created within Lotus notes and attach a sheet from the workbook. This
would then be automatically sent to a distribution list. I would
prefer if the process could be automatically scheduled via code say
every two hours, so the user wouldnt have to input in the process. I
know I'm asking the world here but can anyone help?


Regards,

Chris

Chris
Check out

http://groups.google.com/groups?hl=n...llglob al.com

Note: This topic has been discussed at least twice in the last year. You
might want to do a google search on newsgroups to find answers!

Alex J

"Chris" wrote in message
m...
Hi,

Currently I have a shared excel file that is open 24 hours a day, it
records warehouse information in many forms. I am wanting to either
schedule or have a button on excel that initiates a email to be
created within Lotus notes and attach a sheet from the workbook. This
would then be automatically sent to a distribution list. I would
prefer if the process could be automatically scheduled via code say
every two hours, so the user wouldnt have to input in the process. I
know I'm asking the world here but can anyone help?


Regards,

Chris