+ Reply to Thread
Results 1 to 3 of 3

Auto-generated emails from Excel

  1. #1
    Registered User
    Join Date
    08-28-2010
    Location
    columbus, oh
    MS-Off Ver
    Excel 2003
    Posts
    5

    Auto-generated emails from Excel

    Hi -

    I am working on a Gantt chart template to be used by a workgroup, each member completing different tasks, each reliant on the previous task's completion. What I am looking to do is have an auto generated email sent to the person completing the next task when the previous task is completed. Also, the sheet will be saved, edited and resaved on a Sharepoint site.

    For example, in the attached sheet, I would like an email to be generated when a date is entered in column H, Actual Complete Date, to let the person responsible for the next tast know that they can begin their task.

    For now, those needing email notification is within one specific work group, but the template would have application in other areas, so understanding how to adjust who receives the emails would be valuable to me.

    From my previous searches it looks like this will involve some work in VB, in which I have limited knowledge. But, I'm a quick learner and would appreciate any help/advice anyone would be able to give.

    Thanks in advance,
    Walt
    Attached Files Attached Files
    Last edited by whlewis; 08-28-2010 at 02:56 PM.

  2. #2
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Re: Auto-generated emails from Excel

    Mr. Rondebruin is the leading resource on this issue. His code examples can be read at the following address:
    http://www.rondebruin.nl/sendmail.htm

    Sending emails is a complex and advanced form of vba. You may need some coding assistance, particularly, as it relates to integrating his code examples with your particular application.
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

  3. #3
    Registered User
    Join Date
    08-28-2010
    Location
    columbus, oh
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Auto-generated emails from Excel

    Thanks for the info

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1