Hi, I have tested this for about 2 weeks now and everything is great. It works in a shared worksheet also! Right now I am manually executing the macro. Can I have it setup where it sends the email out everyday at 6:00pm for all of tomorrow's appointments automatically? Any help will be great! Thanks