+ Reply to Thread
Results 1 to 2 of 2

Auto email notifications activated by cell date

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    8

    Auto email notifications activated by cell date

    Greetings all.

    I've done a search on this, but the one that best describes how to do this was a bit over my head, to be honest... I know my way around Excel to do most of the basics. I can even use macros! Well, sometimes...

    Anyway, I've attached the spreadsheet I need help with. I am starting up a database of companies that work for us. This database will contain all the details of the companies, their contacts, addresses, emails etc. Column O of the spreadsheet (Insurance expiry date) is the one I need the help with. In each of the cells under column O there will be a date entered manually. I'd like the spreadsheet to email 3 different addresses (if possible) when this date is within 10 days of expiry.

    Because I'm not too good with Visual Basic or how code works, I'm after an idiot's guide as to how I might go about doing this. I've seen that other people have solved this problem, it's just that the steps that they've followed are beyond a mere mortal like me.

    Any help or suggestions will be gratefully received.

    Ron
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-20-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Auto email notifications activated by cell date

    Bump...

    Sorry, but I'd be very grateful if someone could point me in the right direction.

    R

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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