Results 1 to 13 of 13

Email Specific Cell Values When Cell in Row is Changed to "Yes"

Threaded View

kreiner2006 Email Specific Cell Values... 05-05-2019, 03:59 PM
MatrixMan Re: Email Specific Cell... 05-05-2019, 05:50 PM
kreiner2006 Re: Email Specific Cell... 05-05-2019, 06:18 PM
MatrixMan Re: Email Specific Cell... 05-05-2019, 06:38 PM
kreiner2006 Re: Email Specific Cell... 05-05-2019, 07:17 PM
MatrixMan Re: Email Specific Cell... 05-05-2019, 07:27 PM
MatrixMan Re: Email Specific Cell... 05-05-2019, 07:29 PM
  1. #1
    Registered User
    Join Date
    02-05-2019
    Location
    St. Louis, MO
    MS-Off Ver
    365
    Posts
    13

    Email Specific Cell Values When Cell in Row is Changed to "Yes"

    I need to have the attached spreadsheet automatically send an email when a cell in the range is changed to "Yes".

    I've been able to get the email to send, but I cannot figure out how to get values from other cells in the row of the changed cell to the email body and subject.

    When Column L is changed to "Yes" the email should automatically send to an email with the subject: *Column A Value* "ready to schedule processing training."

    Body should include: *Column A Value*", CO:"*Column B Value* "is ready to schedule training for the switch to online processing. Your contact is *Column K Value* and their next processing date is" *Column M Value*.

    Please let me know if you need any other information.

    Thank you in advance!
    Last edited by Paul; 09-26-2019 at 01:17 PM. Reason: Removed attached file due to contents (sensitive/private information).

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 05-02-2019, 02:18 PM
  2. [SOLVED] Identify specific numeric values in a cell such as "1" without counting "11" as two "1"s
    By MHanna39 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-03-2019, 01:35 PM
  3. VBA to create a "note" or a few sentences based on specific cell values.
    By Nerfmagnet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2016, 02:31 PM
  4. Copying specific cells based on cell value "P" or "O" to sht1 or sht2
    By Ity007 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-01-2016, 07:53 AM
  5. Replies: 3
    Last Post: 06-05-2015, 01:55 PM
  6. Replies: 3
    Last Post: 01-29-2015, 02:36 PM
  7. Displaying Multiple "IF" Condition Values Into One Specific Cell
    By BigFeat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2005, 08:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1