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.
A nice concise application you need here. Consider it done. Via CDO. The Excel range will be transformed into HTML, so the recipients will be getting a friendly looking message; additional HTML formatting can be implemented. In an additional worksheet we add a log of the emails sent.
$120 USD in 5 days
4.9 (28 reviews)
5.6
5.6
4 freelancers are bidding on average $111 USD for this job
Dear Sir,
Today I have found this job post and i am very interested in your job post involving these skills. I believe my skills would be ideal for your project. I can complete this job within the required time period. I hope you would kindly consider my application and let me serve you up to your satisfaction.
Thanking you Sincerely
Jimar