Send email with macro when date is matching with current date

S

sarat47

New Member
Joined
Feb 10, 2013
Messages
6
Hi Everyone

From the beow input data, I would like to send a mail to the Product Incharge hoder (column C) keeping cc to Manager 2 and Manager 3 based on condition ->when the Product sampling date (Column G) is matching with current date.

The mail body will be like below

Subject: (Print Product List name from column A) F
or update e.g Biscuit for update

Email body:
Dear x,

Product list <name of="" product="" from="" column="" a=""> has to be review on <date from="" column="" h="">


(A copy of the matching record will be displaced with column heading for data from col A, B and I-N like below)

Product List NameStockDiscussionProduct Checklist Ready (by)Review from all brokerSampling QualityApproval from site HeadHead review date
Biscuit12.08-Jun-20168-Jul-201618-Jul-201628-Jul-20167-Aug-201617-Aug-2016

<tbody>
</tbody>

Regards


-------
I am not able to attach the excel file. so copy input for your reference
Product List NameStockProduct Incharge hoderManager2Manager3Approval date of current stockProduct sampling dateReview Due dateDiscussionProduct Checklist Ready (by)Review from all brokerSampling QualityApproval from site HeadHead review dateNotification for FinalizationFinalization, approval and release (by)Release dateTotal daysReview Over
Biscuit12.0kurtis@abc.comrubi@abc.comBan@abc.com24-Sep-201529-May-201623-Sep-20168-Jun-20168-Jul-201618-Jul-201628-Jul-20167-Aug-201617-Aug-201622-Aug-201611-Sep-2016
Five star23.0Lucy@abc.comAsmi@abc.comron@abc.com16-Apr-20151-Mar-201615-Apr-201611-Mar-201610-Apr-201620-Apr-201630-Apr-201610-May-201620-May-201625-May-201614-Jun-201610-Jun-2016
Choco111.0neish@abc.comhooo@bcd.comron@abc.com11-May-201526-Mar-201610-May-20165-Apr-20165-May-201615-May-201625-May-20164-Jun-201614-Jun-201619-Jun-20169-Jul-201612-Jul-2016
Swissroll43.0lono@abc.comdris@abc.comron@abc.com29-Sep-201514-Aug-201628-Sep-201624-Aug-201623-Sep-20163-Oct-201613-Oct-201623-Oct-20162-Nov-20167-Nov-201627-Nov-2016
Detttol65.0nie@bac.comran@god.comron@abc.com29-Sep-201514-Aug-201628-Sep-201624-Aug-201623-Sep-20163-Oct-201613-Oct-201623-Oct-20162-Nov-20167-Nov-201627-Nov-2016
Paneer890.0le@lei.comha@abc.comron@abc.com24-Sep-20154-May-201623-Sep-201614-May-201613-Jun-201623-Jun-20163-Jul-201613-Jul-201623-Jul-201628-Jul-201617-Aug-201615-Aug-2016

<tbody>
</tbody>



Thanks in advance</date></name></product>
 
Last edited:

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
The good news is that this is do'able.

There are lot's of VBA scripts on this forum that will show you how to email from Excel. You will have to adjust them slightly for your needs, and I would suggest a couple of helper columns, one column that would display whether an email should be sent (Psuedo) =IF(DATE A = DATE B,"Y","N") so for a period of 24 hours a Y would appear in the helper column and the second helper column would record a "Y" if an email had been sent.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Pivot Table Date Filters not formatting correctly
Replies
1
Views
508
Shortmeister1
S
A
  • Question
Negative values sum
Replies
4
Views
288
Scott Huish
Scott Huish
W
  • Solved
Validate month based on contract dates & Calculate number of weeks in that month to calculate hours booked per month
2
Replies
16
Views
1K
phiero21
P
V
  • Solved
Week Number
Replies
2
Views
106
vmjan02
V
W
  • Solved
Usign the =sort function in a Dynamic Array to sort by Month
Replies
3
Views
213
Fluff
Fluff

Forum statistics

Threads
1,214,863
Messages
6,121,978
Members
449,058
Latest member
oculus

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top