Results 1 to 24 of 24

Macro needed to send auto email with contents of cell on corresponding row as trigger cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2015
    Location
    Houston, TX
    MS-Off Ver
    MS Office 2010
    Posts
    14

    Macro needed to send auto email with contents of cell on corresponding row as trigger cell

    I have a spreadsheet that tracks production status.
    At the end of a project the project manager updates the project to 95% because it wont be 100% complete until it goes through our Quality department.


    I have completed the macro to send an email when any part of the production is at 95% (Completion percents are in column D)

    Now, the part I am having trouble on is, once the email is generated.. I would like the subject line to be the title of the document that is ready to be checked by our Quality Department.

    The title of the documents is in column B.

    So to recap, Column B has a Document Titles, column D has the Percent Complete.
    My current macro sends an email to the QC Department when a certain document is at 95% (column D), but in that email I would like the title of the Document which is the same row, but in column B to generate in the subject line or in the body of the email even.

    PLEASE HELP!

    Thanks a Bunch!!
    Last edited by ExcelShi; 06-15-2015 at 11:11 AM. Reason: Title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to copy Code / Macro Code / 2 Sheets
    By paxile2k in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2014, 12:59 AM
  2. [SOLVED] Code to create Macro Button and Assigning Macro code
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2014, 11:30 AM
  3. Unable to edit macro recording code to be a relative code.
    By holaitsme in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2014, 10:51 AM
  4. [SOLVED] Excel Macro Visual Basic code not looking at all sheets with second section of code.
    By Heinrich Venter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 08:26 AM
  5. [SOLVED] Code with last column and last row to recognize multiple commands through the macro code
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-13-2014, 04:10 PM

Tags for this Thread

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