Excel - VBA - Email range of data on a schedule.

Excel - VBA - Email range of data on schedule. I have a spreadsheet that will have data on tab “A”. The data changes every minute. The range size will change often. I need to have the data emailed to an address on tab “B”, NOT using the computers email application (Outlook, Outlook Express, AppleMail, or any other APP). There should be a button to choose between sending now OR, automatically sending at an interval from a start time to an end time, also only send on weekdays. This should work on all versions of excel from 2003 to current (including Office for Mac versions). 1. Copy the data into the body of an email (Range name is "RangeToEmail"). 2. Date and time in the subject line. 3. Send using web. DO NOT use the computers email client (Outlook, Outlook Express, AppleMail, etc) similar to CDO sendmail. 4. Need one button to send to email (with me as bcc), AND 5. Need an option to send automatically every (interval) hour from (start) 9am to (end) 4pm where I can change the interval, start and end also days of week to send (M,T,W,Th,F). The DATA will be on tab "A" On tab "B" I would like to have the inputs: target email, option to SEND NOW or start AUTO emails, interval, start time, end time, days of week to send. The data needs to be copied from tab"A" and sent as HTML in body of email. The range will change from day to day and hour to hour.