+ Reply to Thread
Results 1 to 9 of 9

Sending an email when value is below 50, need to reference item name too.

  1. #1
    Registered User
    Join Date
    01-02-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    31

    Sending an email when value is below 50, need to reference item name too.

    Cover Order Sheet.xlsx

    HI

    I would like to have the attached excel spreadsheet send me an email when the values in N5 to N200 fall below 50 and the company name in O be included in the subject line "Company Name has less than 50 covers in stock".

    I am stymied... have read other posts/answers and they all make sense but I cannot transpose for my file.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Sending an email when value is below 50, need to reference item name too.

    Do you want an email for EACH company. or one email with ALL companies below threshold?

    Do you have Outlook on the machine that is using the spreadsheet?
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    01-02-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Sending an email when value is below 50, need to reference item name too.

    Quote Originally Posted by Tinbendr View Post
    Do you want an email for EACH company. or one email with ALL companies below threshold?

    Do you have Outlook on the machine that is using the spreadsheet?
    Hi Tinbender, thanks for the reply.

    Yes, each brand/company will fall below 50 at different times
    Yes, Outlook is used as the email program

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Sending an email when value is below 50, need to reference item name too.

    Change the email address in the email subroutine.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-02-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Sending an email when value is below 50, need to reference item name too.

    THANK YOU Tinbendr! That is perfect!

    Is there a way to make it automatic?

    Opps... please don't hate me but, can the info in the P column also be included? Beside the company name?
    Last edited by IreneADS; 01-03-2014 at 11:44 AM.

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Sending an email when value is below 50, need to reference item name too.

    At what event would the macro be run? (Automatic, when?)

  7. #7
    Registered User
    Join Date
    01-02-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Sending an email when value is below 50, need to reference item name too.

    In a perfect world, every morning, but realistically, whenever I open the file.

    Opps... please don't hate me but, can the info in the P column also be included? Beside the company name?

  8. #8
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,124

    Re: Sending an email when value is below 50, need to reference item name too.

    Quote Originally Posted by IreneADS View Post
    whenever I open the file.
    Done!

    can the info in the P column also be included? Beside the company name?
    And done!
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    01-02-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Sending an email when value is below 50, need to reference item name too.

    Thank you! You are amazing as well as helpful!

+ 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. automation/macro for sending email to multiple email address
    By saurabhlotankar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2013, 12:13 PM
  2. Sending HTML email via excel VBA - arriving as RTF email
    By Shuter1 in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2012, 04:35 AM
  3. Sending Email Dependent on Default Email Client
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2010, 06:51 AM
  4. Sending an email from Excel to multiple email addresses
    By insanity66 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2009, 02:01 PM
  5. Sending email using users preferred email client
    By deadlyduck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2009, 06:29 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