Chris,

Great stuff!! I changed low date and high date to date rather then
string and its working awesome.
Only one problem, if there are no rows with the date then it doesn't
work. Is there anyway to stop this?

What I want to do with this now is the following:

If there are is data that fall in the dates then send an email if not
end sub without error and run the next macro.

Thanks so much for the help