1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Sending a Automated Email Through Excel

Discussion in 'Business Applications' started by Squick, Feb 7, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Squick

    Squick Thread Starter

    Joined:
    Feb 7, 2012
    Messages:
    5
    Good Day,

    I would like assistance in creating a code that will generate a automated email to specified receipients when a date is entered into a specific cell. I have attached a sample spreadsheet. When a "date" is added in column M, it automatically generates a email to specific recepients notifying the receipients that the specific unit number in column A has been completed.

    For Example:

    Good Day,

    This is to notify you that unit *** (from colum A) is complete and ready for your team.

    Thank You,

    xxxx

    Thank you very much for the assistance!
     

    Attached Files:

  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    Hi welcome to the forum.

    See returned example.

    A trigger on change macro in Sheet1 and teh VBA MailModule in the VBAProject

    Chnage a date or add it in the date column to trigger the macro
     

    Attached Files:

  3. Squick

    Squick Thread Starter

    Joined:
    Feb 7, 2012
    Messages:
    5
    Wow! Thank you very much! It works great!
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    :)
    Don't forget to use the "Mark Solved" button to close the post
     
  5. Squick

    Squick Thread Starter

    Joined:
    Feb 7, 2012
    Messages:
    5
    Good Day Hans,

    Thanks agian for creating this code, it worked out great. However, my company just change from Oulook to Gmail. Is it possible for the code to work for gmail as well?
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,553
    First Name:
    Hans
    I haven't used it myself but I imagine you can find the answer in the attached link

    http://www.rondebruin.nl/cdo.htm

    There's a sample file there too for Gmail
     
  7. Squick

    Squick Thread Starter

    Joined:
    Feb 7, 2012
    Messages:
    5
    Thanks for the quick response and the link as well.
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1040026

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice