+ Reply to Thread
Results 1 to 13 of 13

Macro to Automatically E-mail Reminders based on date in Cell

  1. #1
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Macro to Automatically E-mail Reminders based on date in Cell

    Good Afternoon,

    I've tried posting this in a couple of different forums and haven't had any response.

    I've noticed this has come up quite often, but though I have a basic understanding of programming I have very little experience with VB and when trying to steal other code online I can't seem to re-write the bits to shape it to my workbook.

    I'd like a macro that when I open up my spreadsheet automatically detects what documents have reached their due date then issues a reminder to the document originator. Once the reminder has been sent a flag will be placed in the 'reminder sent' column to stop duplicate e-mails being sent. I'll be opening the workbook daily with windows schedule

    I've attached a sample workbook which already has a basic macro in place, which will give a rough idea of what I'm trying to achieve.

    Any help, coding or advice would be greatly appreciated.

    Many Thanks in Advance!

    Richard
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-22-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Hi,

    I think you haven't search properly to websites... you will get your reply if you search properly...
    So, you need to explore your search options.

    RK

  3. #3
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    I've searched a heap of websites for this, and it's not that I can't find similar problems from people, or VB coding that I can try. It's just that none of it quite suits what I'm trying to achieve. Anything that does seem to suit my application is too complicated for me, I have no idea how to alter the code to fit my workbook.

  4. #4
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    So I found this,
    http://www.excelforum.com/excel-prog...in-date-2.html
    It works quite well and is very similar to what I'd like to achieve.
    If someone could help me edit this to suit my workbook I'd be very greatful!

    Also apologies Leith Ross if you just got an e-mail from me... Looks like the automatic e-mails are working though!

  5. #5
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Bump - Someone Please help

    Honestly I've been searching the web for bits of coding and trying various things on my worksheet for the past week.

  6. #6
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Bump - I'm not giving up on this.

  7. #7
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Fit like loon?
    Furry boots are ye in Aibirdeen? Is't caul' up air th' noo?

    Vba to send e-mails isn't my forte, never tried before! See if this helps
    Please Login or Register  to view this content.
    P.S.
    Please don't send messages regarding posts to individual members unless specifically requested, it's against the forum rules.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  8. #8
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Aye it's baltic! Surrounded by sna! Based in a company oot in northfield!

    fit's the wither like doon in Fife?

    That's working brilliantly, Thanks. Is there anyway I can get the Macro to run when the spreadsheet opens

    I tried adding this before it, but I've no idea if that's how its meant to be done and it doesn't appear to work.
    Please Login or Register  to view this content.
    P.S

    Aye, sorry about that. I wasn't sure if that rule meant I wasn't allowed to approach the individual to tackle it by themselves in private, thought it might have been okay to invite you along to the thread. I'll ken for future like.

    Thanks so much for responding regardless!

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Aye it's baltic! Surrounded by sna! Based in a company oot in northfield!

    fit's the wither like doon in Fife?

    It's like a foreign language


    thought it might have been okay to invite you along to the thread
    Actually, I believe PM'ing someone, or even several people, is within the rules provided you are asking them to look at a thread, rather than asking them for personal, and possibly off board, assistance. Many folk, me included, still don't appreciate the use of PMs this way. I take the view that, as I'm looking at the board all the time, if I see a thread I can answer, I will do so. That's tempered by whether or not other people are already trying to help and/or if it is of particular interest to me. So, be wary and use the PM functionality judiciously.

    This code:

    Please Login or Register  to view this content.

    has to be in the Workbook Class module, not a standard module. Double click on the Workbook in the VBA window and paste the code there.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  10. #10
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Actually, I've solved that little one myself!

    You learn something new everyday kids.

    Cheers Marcol!

  11. #11
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    It's nae bad here in Burntisland, better than the Broch far am fae a'll bet!

    That's working brilliantly ...
    Aye, better lucky than guid ...

    You need to call the Sub from the Workbook module, not from a standard module

    In the VBa editor project pane double-click "ThisWorkbook"
    Then paste this in the resultant window
    Please Login or Register  to view this content.
    It would be safer to change the sub in "Module1" to this, it runs the code specifically in sheet "PPU Document Register"
    Please Login or Register  to view this content.
    Then this would be enough in the workbook module
    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    01-21-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    258

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Ah, That's great!

    Cheers my man, I'll update my code now!

    Really appreciate your help!

  13. #13
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Macro to Automatically E-mail Reminders based on date in Cell

    Thanks for the rep

+ 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