Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sending alerts by email

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet that tracks repairs to customers' equipment. One of the columns is required delivery date. Is there a way to send an alert by email when today's date is within five days of the required delivery date?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    set the alert you request in conditional formatting

    so when 5 bays B4 the alert pops up...

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    eH!

    posted on its own...

    then set the email to trip and sent as requited.. your need VBA for this sll in one go, on set conditional formal and you can them do manula and you have control,,, poss i prefer this.. as then i could check YES or no to send as you cant un send emails if they have the smallest error or any other reason

    Some help i hope


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

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
  •