Results 1 to 5 of 5

Sending EMail from Excel based on value of cells

This is a discussion on Sending EMail from Excel based on value of cells within the Excel Questions forums, part of the Question Forums category; Normal 0 false false false EN-CA X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; ...

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    14

    Question Sending EMail from Excel based on value of cells

    Hello

    I was wondering if I could get some help with an excel task I have been asked to do. I maintain stats for a local fire department and I was wondering if someone would be able to point me in the right direction.

    I am looking to have an email sent out to an individual member when either their Call %, Training %, or Meeting % falls below a threshold - in this case 20% for calls & meetings - and 45% for training.

    I do not require the mail to be automatically sent - I would prefer a button to call the script so I can do it manually will be using Excel 2010, Windows 7, and Outlook 2010 (if it matters).

    Also I would like to in the email be able to add a Subject, and body as well to include their name, and the 3 fields (calls, training, & meeting) percentages, as well as a header for each.

    - thanks for the help ...

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,466

    Default Re: Sending EMail from Excel based on value of cells

    Microsoft MVP - Excel

  3. #3
    New Member
    Join Date
    Mar 2012
    Posts
    14

    Default Re: Sending EMail from Excel based on value of cells

    Thanks

    This is what my excel sheet looks like:
    Will the above code work if I want to send an email to each member woth only their data?


    name email call % train % mtg %
    Fire 1 fire1@fire.ca 25% 45% 8%
    Fire 2 fire2@fire.ca 40% 12% 72%
    Fire 3 fire3@fire.ca 12% 88% 5%
    Fire 4 fire4@fire.ca 58% 100% 12%
    Fire 5 fire5@fire.ca 15% 0% 100%
    Fire 6 fire6@fire.ca 22% 12% 88%

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    69,466

    Default Re: Sending EMail from Excel based on value of cells

    Did you download and look at the sample file in the link I posted?
    Microsoft MVP - Excel

  5. #5
    New Member
    Join Date
    Mar 2012
    Posts
    14

    Default Re: Sending EMail from Excel based on value of cells

    looking at it now - thought i would post a sample of my excel sheet

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com