Hi Gmayor,
Thank you for your help anyway. I moved your code to a regular module, went into the rule and ran it but nothing happened. Maybe if I put the code into excel and try to run it it will work. Back to the drawing board. If it works, I was thinking of putting the excel workbooks in my startup so it will open when I sign in. If the code is in thissession hopefully it will automatically run. The I could set it up to do the additional code (My code) which I know works because I have been running that code every day. I just have to open it up each day and run the macros.
Thanks anyway for your help. It's not easy for me because I am just a beginner. I have a lot more to learn.
I did set up another rule see attached to see if it will work from outlook. Not likely. see attached.

Attached Images

ProcessAttachment Rule.JPG (58.7 KB, 23 views)