Email Daily Reminders from Monthly Calendar

Hello,

Is there any way in excel to send auto email reminders from a monthly calendar based on today's date.

For example, today is Dec 22 and I have a cell labelled Dec 22 followed by 5 cells down for input. I want to pull the entire range - Date and 5 cells on a daily basis and automatically email without the need to open the file. If there is no way to accomplish this, then a auto reminder set to timevalue every 24 hours, so it sends the daily snapshot to the group.

Any template or macro that can do this would be much appreciated.

Thank you,
Newb

You need to open your file and run a code exploiting this command "Application.Dialogs(xlDialogSendMail).Show".
This opens your eMail, you then need to Cc/paste the contents of the 5 cells into the body message including the date