+ Reply to Thread
Results 1 to 1 of 1

Send service reminder mail based an hour meter reading

  1. #1
    Registered User
    Join Date
    10-02-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    19

    Send service reminder mail based an hour meter reading

    Dear Team,

    I want to send service reminder mail based on hours reading updated on the list.

    Every month i am updating hours reading on my excel.

    Once i click send mail button the remainder mail goes to customer along with spares details with condition.

    My condition is

    I am having the list of customers details with different machine model.

    My service interval is first service is 50Hr and after that every 500 hrs (50, 500, 1000, 1500, 2000, 2500, 3000.... Hrs).

    If machine is reached 500 hrs customer need to do the machine service. For that i want to send remainder mail for customer when it is reached 400 hrs itself ie. between 400 to 500 hrs i want to send remainder mail.

    I am having recommendation list machine and hour wise.

    Example,

    PAWAN K ROCHLANI customer having GP 2400 model machine and their machine running hour is 425. So i want to send mail with 500hrs spares list which is available on Sheet "GP 2400".

    And also send separate mail to my spares department for send quotation the same recommendation list along with customer details which is available on Sheet "Customer Data".

    Note: Till 2000 hrs the recommendation list is different. From 2000 hrs to every 500 hrs (2000, 2500, 3000, 3500 ... Hrs) recommendation list is 2000 Hrs list.

    Can any one help me for this .

    I attached my file here.
    Attached Files Attached Files

+ 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. Reminder Mail Trigger Criteria Based
    By fareedexcel in forum Excel General
    Replies: 1
    Last Post: 10-19-2018, 04:09 AM
  2. [SOLVED] send Reminder Email if cell value reached by selective case through outlook mail
    By Anisusa in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-09-2017, 03:32 PM
  3. Another meter reading spreadsheet that needs help
    By danb1203 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2014, 08:47 AM
  4. Meter reading calculator based on date
    By bd528 in forum Excel General
    Replies: 8
    Last Post: 07-16-2013, 04:31 AM
  5. Send reminder mail from excel using outlook
    By arunsny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2011, 09:22 PM
  6. Meter Reading Problem
    By Dowjd in forum Excel General
    Replies: 4
    Last Post: 01-02-2011, 02:44 PM
  7. meter reading formulas
    By freud1 in forum Excel General
    Replies: 2
    Last Post: 08-14-2008, 08:49 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