+ Reply to Thread
Results 1 to 2 of 2

Automatically Email Excel Sheet to Hyperlinked Address After Data Entry

  1. #1
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

    Automatically Email Excel Sheet to Hyperlinked Address After Data Entry

    I am trying to figure out how to make one of my sheets in my workbook to be automatically emailed to me and cc'd to others when my employees finish entering data in the sheet. I will then always know when someone has updated the sheet. I have attached the workbook. The Sheet is named "Communication Log". I currently have VBA Code applied for it to automatically lock the the cells after they are typed in. The password to unlock the sheet is "Password", (Capital "P"). I would like to be able to enter the email addresses that the sheet will be sent to, somewhere on the sheet, maybe directly to the right at the top. My email address is: [email protected]. for test purposes. Any help would be greatly appreciated.

    Thank you
    Last edited by Hillster; 09-15-2012 at 01:37 PM.

  2. #2
    Forum Contributor
    Join Date
    09-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    176

    Re: Automatically Email Excel Sheet to Hyperlinked Address After Data Entry

    I have a formula for linking the sheet to hyperlinked email which I have posted below but is it better to write VBA code for it? I cannot get the data in C361 to go into the body of the email. Desperately need help with this.

    thank you so much for any help.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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