Announcement

Collapse
No announcement yet.

Auto Email When Cell Reaches A Value

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Craign
    started a topic Auto Email When Cell Reaches A Value

    Auto Email When Cell Reaches A Value

    --------------------------------------------------------------------------------

    Help,
    I am trying to set up my spreadsheet, with a macro, to email me and my supervisor when a cell reaches a date. I have already created a countdown column so say when it reaches 10 days left I would like it to email me automatically with a notification of an event to come. I would like this to happen for columes "G5" thru "I5", and down thru row 50 as of Know. But I would like to be able to add rows when I need to. I have no VBA skills so feel free to dumb it down for me, I donít even know if this is possible. Attached is my spreadsheet.
    Thanks in advance for any help from anyone.
    I am willing to pay 75$ + for anyone who can write me this code so that all I need to do is copy and past it into a module.
    Thanks again.
    Attached Files
    Last edited by Dave Hawley; September 16th, 2008, 09:20.

  • felipeboralli
    replied
    Re: Auto Email When Cell Reaches A Value

    Alas, I had to expand the names in Column A to be less error-prone.

    Leave a comment:


  • felipeboralli
    replied
    Re: Auto Email When Cell Reaches A Value

    It is a working version by now.

    The Macro will run everytime the workbook is opened.
    Only working for columns G H I, but rows are ranged automatically.
    Will automatically send a e-mail to the addresses especified in P1 and Q1, containing all warning. After sending, will mark warnings already sent as "Sent". So probably, the first time you run you will get a lot of warnings for the ones allready old, but then it will start working properly.
    Attached Files
    Last edited by Dave Hawley; September 16th, 2008, 09:18.

    Leave a comment:


  • Dave Hawley
    replied
    Re: Auto Email When Cell Reaches A Value

    If they correspond via email or PM, then yes.

    Leave a comment:


  • Stormseed
    replied
    Re: Auto Email When Cell Reaches A Value

    Originally posted by Dave Hawley
    Please keep all correspondence in this thread, thanks.
    Hi Dave

    Would this mean that the resolution or the answers for solving the initial question asked by the OP would be hidden or a secret ? I mean, if the solution is not posted on the thread ?

    Just anxious to know about it.

    Regards -Stormseed

    Leave a comment:


  • Dave Hawley
    replied
    Re: Auto Email When Cell Reaches A Value

    Please keep all correspondence in this thread, thanks.

    Leave a comment:


  • felipeboralli
    replied
    Re: Auto Email When Cell Reaches A Value

    ok .
    will get in touch with you soon about the development

    Leave a comment:


  • Craign
    replied
    Re: Email When Cells Reach A Value Of 10

    Ok, I guess I should have included that. I use Microsoft Outlook 2003. As far as how often I’ll open the spreadsheet, probably daily although I thought I could create a task to check it when it’s not in use.
    Thanks
    Craign

    Leave a comment:


  • felipeboralli
    replied
    Re: Email When Cells Reach A Value Of 10

    I am intereste in your offer.
    Now i need to know how often do you open you spreadsheet, and which program do you use to send e-mails.

    Leave a comment:

Working...
X