VBA to email based on cell value in column

B

Bob_ipc

Board Regular
Joined
Oct 18, 2017
Messages
67
Office Version
  1. 365
Platform
  1. Windows
Hey all! I'm looking for some help on a VBA code that will send an email any time a cell value in range A7:A50 changes to "Expires Soon". I am not well versed in VBA's and could use a helping hand please.

Thank You.
 
Sort by date Sort by votes
Ok, but the workbook would need to be open for that formula to work ?????
 
Upvote 0

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

spacecaptainsuperguy
  • Question
Simple VBA for Outlook - Copy last sent email
Replies
0
Views
338
spacecaptainsuperguy
spacecaptainsuperguy
B
  • Question
Automating Outlook Using Custom Tags in Email Templates
Replies
0
Views
381
brncao
B
R
  • Question
Mail merge to insert the picture in the mail body and schedule the email
Replies
0
Views
794
rafeek4u
R
L
  • Question
Office JS Excel: Event Handlers Slow to fire
Replies
1
Views
196
jkpieterse
jkpieterse
H
  • Question
Return the number of unique values in a date range that contain a key sentence
Replies
6
Views
496
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,215,417
Messages
6,124,791
Members
449,188
Latest member
Hoffk036

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