+ Reply to Thread
Results 1 to 4 of 4

Send email with cell info if true

  1. #1
    Registered User
    Join Date
    10-24-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    2

    Question Send email with cell info if true

    Hi, hopefully you guys can point me in the right direction. I've been trying to find the correct way to do what I want but I am not very skilled and thus need your help.

    My ultimate goal, is to send two people an email, when document is saved, with cell information for each cell that are "true".

    Row A his the stock #
    Row F his the Repair to be done

    I want an email being sent when saved, for each line with "Yes" in Row F, the cell content of Row A (the stock #) is written in the email.

    Is that possible?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Send email with cell info if true

    First, I assume you mean column A and column F.

    Here is code that will do what you describe. This assumes that you have Outlook installed; it uses Outlook to send the mail. You will also need to set the library reference for Outlook. This code must be put in the module called ThisWorkbook.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    10-24-2014
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re: Send email with cell info if true

    Awesome!!! That is exactly what I needed. Thank you very much for your help!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Send email with cell info if true

    You're welcome. That was fast--I figured we would go back and forth a few times on this. Good luck!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  2. Send email to recipitent address which is in a cell, if cell CHANGES to true
    By shiftyspina in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2014, 01:05 PM
  3. [SOLVED] Code to send email if cell contains certain info
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-03-2013, 10:43 PM
  4. Make a sheet with selectable info, send email using info selected
    By DwayneHeight in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2007, 12:18 PM
  5. [SOLVED] if condition is true than send info to another work sheet
    By jwpmann in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2005, 05:05 AM

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