+ Reply to Thread
Results 1 to 2 of 2

automatic email to generate after each cell change

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    birmingha, england
    MS-Off Ver
    2010
    Posts
    25

    automatic email to generate after each cell change

    Hi there,

    I was wondering if its at all possible to automatically send an Email from Microsoft Outlook when a cell has changed.

    The columns that apply to the cells are stated below. An email should only be generated if a cell change occurs from row 7 and below.

    If column L changes then email send to Rob/Adrian indicating change in spreadsheet
    If column N changes then email to send to Roger/Adrian indicating change in spreadsheet
    If column P changes then email to send to Roger indicating all 3 parties have completed their approval.

    If column S changes then email send to Rob/Adrian indicating change in spreadsheet
    If column U changes then email to send to A Vale/Adrian indicating change in spreadsheet
    If column W changes then email to send to A Vale indicating all 3 parties have completed their approval.

    If column Z changes then email send to Rob/Adrian indicating change in spreadsheet
    If column AB changes then email to send to M Redfern/Adrian indicating change in spreadsheet
    If column AD changes then email to send to M Redfern indicating all 3 parties have completed their approval.

    If column AG changes then email send to Rob/Adrian indicating change in spreadsheet
    If column AI changes then email to send to A Buchanan/Adrian indicating change in spreadsheet
    If column AK changes then email to send to A Buchanan indicating all 3 parties have completed their approval.

    If column AN changes then email send to Rob/Adrian indicating change in spreadsheet
    If column AP changes then email to send to R Court/Adrian indicating change in spreadsheet
    If column AR changes then email to send to R Court indicating all 3 parties have completed their approval.


    Also where would I enter the coding? the worksheet? the module?


    The subject of the Email should read:

    "Data Access spreadsheet change"

    Body of email:

    "All change has been made, please edit accordingly"

    Thanks

    Sam.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: automatic email to generate after each cell change

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to generate an email with cell contents in it...
    By willm in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-13-2016, 10:26 PM
  2. Generate single cell listing from a column of email addresses
    By rszanti in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-10-2015, 04:41 PM
  3. Automatic send email change from Outlook to Lotus Notes
    By thuydo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2015, 12:19 AM
  4. VBA for automatic email upon cell change via other formula
    By Muzza86 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2014, 10:50 AM
  5. Automatic email generate
    By shady_ryo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2014, 11:49 PM
  6. How to generate automatic date when we enter data in a cell
    By semeer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 10:24 AM
  7. Generate email from worksheet based on multiple cell values
    By mattbro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2012, 03:22 PM

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