+ Reply to Thread
Results 1 to 5 of 5

Send an email listing cell data when workbook is modified.

  1. #1
    Registered User
    Join Date
    11-11-2013
    Location
    Knoxville, TN
    MS-Off Ver
    Excel 2010
    Posts
    3

    Send an email listing cell data when workbook is modified.

    Hey guys, as the name says, I'm VB challenged. I managed to piece together a code that sends an email to certain users when a document is updated. It works great, but I would really like for it to also list the data/info of the cell or row that was modified. The workbook is basically a log file. Here's what I have...


    Please Login or Register  to view this content.
    Thanks in advance!

  2. #2
    Forum Contributor
    Join Date
    05-10-2012
    Location
    Paris, France
    MS-Off Ver
    2016/365
    Posts
    123

    Re: Send an email listing cell data when workbook is modified.

    Hi

    Can you try this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-21-2013
    Location
    newcastle
    MS-Off Ver
    2011
    Posts
    113

    Re: Send an email listing cell data when workbook is modified.

    did this work?

  4. #4
    Registered User
    Join Date
    11-11-2013
    Location
    Knoxville, TN
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Send an email listing cell data when workbook is modified.

    Thanks....but no dice. This is the email I got...

    " You are receiving this auto-message because this user has issued a new prototype request.
    Please check the log for the number and required documentation
    $C$10y "

    Even if it could display the entire row that was modified, that would be great.... Any ideas?

  5. #5
    Registered User
    Join Date
    11-11-2013
    Location
    Knoxville, TN
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Send an email listing cell data when workbook is modified.

    Bump......

+ 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. How to create a "send email" event once a field is modified?
    By DatacomGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2013, 11:56 PM
  2. Reference cell data in most recently modified workbook in another directory
    By JSebastianRock in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2013, 11:14 AM
  3. Send email integrating cell data into Subject and Body, with attached invoice
    By KarBar110 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 05:36 PM
  4. Script to Send a Single Worksheet from a Workbook via Email Based on a Cell Value
    By cstavr1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2012, 04:00 PM
  5. send an email based on data in specific cell
    By savage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2010, 11:54 AM

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