+ Reply to Thread
Results 1 to 13 of 13

Email reminder sent to the task owner on the projects due date? Please help!

  1. 09-15-2012, 03:10 PM #1
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Post Email reminder sent to the task owner on the projects due date? Please help!

    Hey guys,

    I am having some trouble trying to figure out the VBA for this...

    I use an excel workbook to keep track of upcoming projects sorted by their due dates. In another column we have the name of the person who was assigned the task. I would like an email sent to the task owner the day that the project is "due".

    I was able to make this work without VBA but the formula is long, messy, and doesn't work for a range of projects, just a specific cell that I set a date and name to.. See my attached sheet!

    Can anyone provide me with a code already made that they know of or maybe just give me some information for what I am looking for and I can research it myself?? I really appreciate the help guys.
    project_due_sheet.xlsx
    Reply With QuoteRegister To Reply
  2. 09-16-2012, 12:40 PM #2
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Anyone?? I have been searching and searching and haven't been able to find what I am looking for but I know its possible!
    Reply With QuoteRegister To Reply
  3. 09-16-2012, 04:09 PM #3
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Hello line1260sk,

    Welcome to the Forum!

    I am looking at your workbook and noticed there are two email addresses that start with the letter "G". There are two PM names Guido and Greg. How would I distinguish who is who in your list?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  4. 09-16-2012, 06:46 PM #4
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    That is a good question. None of them have the same email, that was a mistake. Could you try to delete one of them for now to see if it can be solved disregarding that issue?
    Reply With QuoteRegister To Reply
  5. 09-16-2012, 06:49 PM #5
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Hello line1260skr ,

    I can do that for now.
    Reply With QuoteRegister To Reply
  6. 09-16-2012, 06:50 PM #6
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    That would be great! I spent a couple more hours today researching it but I couldn't find anything yet
    Reply With QuoteRegister To Reply
  7. 09-16-2012, 09:18 PM #7
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Hello line1260skr,

    Here are the macros used to send out the emails automatically when the workbook first opens. All of these have been added to the attached workbook.

    The macro NotifyByEmail will send an email using your default email client. It will also automatically encode the body before sending the email.

    All the dates are scanned and compared with today's date. If the dates match and the Project Manager cell is not blank then macro uses the PM name to retrieve the email address. The PM name and the sender's name (Your Name are added to body using the $ and @ characters. Test this out and let me know the results.

    Module1 Code
    Please Login or Register  to view this content.
    ThisWorkbook Module Code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 09-17-2012, 07:37 AM #8
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    So I see the macros in the sheet obviously, but, unfortunately I do not know how to make it run. I am pretty new to VBA but I thought I at least knew everything about running them.. How do I get the VBA to send the messages?? Nothing loads on workbook startup and my only option is to run the SendNotices Macro but this does not do anything. Would you please offer a little insight into successfully running this macro?
    Reply With QuoteRegister To Reply
  9. 09-17-2012, 10:09 PM #9
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Leigh, could you help me on this last little part? The macro looks great but why am I having such a hard time getting it to work?
    Reply With QuoteRegister To Reply
  10. 09-18-2012, 02:41 PM #10
    line1260skr
    line1260skr is offline
    Registered User
    Join Date
    08-01-2012
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    13

    Unhappy Re: Email reminder sent to the task owner on the projects due date? Please help!

    [BUMP] Does anyone have any idea on how to execute these macros? I would hate for this thread to die unanswered with such great looking macros..
    Reply With QuoteRegister To Reply
  11. 09-18-2012, 07:33 PM #11
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Hello line1260skr,

    The workbook in Excel 2003 format. If you are in fact using Excel 2003 then should not be any issues because I tested it on my system. If macros were not enabled you would be told they weren't. At really have no idea what the problem is. You should post the workbook fro review.
    Reply With QuoteRegister To Reply
  12. 11-24-2012, 09:07 PM #12
    zen_5943
    zen_5943 is offline
    Registered User
    Join Date
    11-24-2012
    Location
    Coventry,UK
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    Hello Mate,

    I was trying to use the code for a similar application (Excel 2007) and had the same issue.
    The macro runs without errors, but cannot see an e-mail being sent based on the date.

    I am sure its something simple, please could you have a look at it.

    Thanks for your help.

    Nik
    Reply With QuoteRegister To Reply
  13. 11-25-2012, 01:38 AM #13
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Email reminder sent to the task owner on the projects due date? Please help!

    zen_5943,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1