+ Reply to Thread
Results 1 to 5 of 5

Have Macro Send Email Only When Cell Contains Text Active

  1. 05-26-2015, 02:13 PM #1
    onelifestyle
    onelifestyle is offline
    Registered User
    Join Date
    05-12-2015
    Location
    Miami, FL
    MS-Off Ver
    365
    Posts
    49

    Have Macro Send Email Only When Cell Contains Text Active

    The macro below is designed to send an e-mail 6, 4, and 3 months before its expiration date (column 14).

    There needs to be one more criteria: Macro should send e-mail only when any cell in Column A contains text ACTIVE.

    Is there a way to include that in the code?

    Thanks!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-26-2015, 03:49 PM #2
    nigelbloomy
    nigelbloomy is offline
    Valued Forum Contributor nigelbloomy's Avatar
    Join Date
    11-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1,011

    Re: Have Macro Send Email Only When Cell Contains Text Active

    I can't test this out, but I think this should work.

    Please Login or Register  to view this content.
    Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.

    <---Click * Add Reputation for all helpful comments. It's like giving a smile.
    Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
    Reply With QuoteRegister To Reply
  3. 05-26-2015, 03:49 PM #3
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Have Macro Send Email Only When Cell Contains Text Active

    You could try

    Please Login or Register  to view this content.
    Martin
    Reply With QuoteRegister To Reply
  4. 05-26-2015, 04:07 PM #4
    onelifestyle
    onelifestyle is offline
    Registered User
    Join Date
    05-12-2015
    Location
    Miami, FL
    MS-Off Ver
    365
    Posts
    49

    Re: Have Macro Send Email Only When Cell Contains Text Active

    Hello mrice, where in the code should I place:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-26-2015, 04:14 PM #5
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Have Macro Send Email Only When Cell Contains Text Active

    If I have understood correctly ...


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro to send an email with an active excel sheet attached
    By megtoma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2014, 11:37 PM
  2. Unable to send user-editable text to Outlook email body based on active cell.
    By m0meehan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-20-2014, 01:51 PM
  3. Create pdf of active sheet and send to email recipient contained in cell use default mail
    By dcsuperman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2012, 10:00 PM
  4. Send email using Active Cell but using external Outlook / Livemail template
    By sellenwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2011, 12:39 AM
  5. Macro to send active worksheet to different email addresses
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2010, 07:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1