+ Reply to Thread
Results 1 to 5 of 5

How to create a "send email" event once a field is modified?

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    7

    How to create a "send email" event once a field is modified?

    I am building an interactive calculator.. See this thread.

    When something is entered in to J13 of this spreadsheet, i want the spreadsheet to create a new Outlook email, with a set subject.. and in the body of the email, i want it to reference the output from H15 and K17 in the body of the email.

    An example.. Customer enters "60" in J13. the output in H15 is FGXMPMPAD-MBF060, and a price comes up of $1000.00. I want an outlook "new email" window to popup, subject is "MPO Priced", and body of the email to read "I've built a price for FGXMPMPAD-MBF060, at $1000.00". And i want it to go to a set email address, and CC a few others..

    Is this possible? hopefully it makes sense.. A copy of the spreadsheet can be found in the original email..

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: How to create a "send email" event once a field is modified?

    create a module in your workbook and copy the below into it
    if you play it it will work , but thats just step one , i'm not sure i understand when you want it to be emailed ? with a push putton a wanring pop-up first or a form where you provide addresses ?

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.

    I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.

  3. #3
    Registered User
    Join Date
    06-25-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to create a "send email" event once a field is modified?

    Quote Originally Posted by hulpeloos View Post
    create a module in your workbook and copy the below into it
    if you play it it will work , but thats just step one , i'm not sure i understand when you want it to be emailed ? with a push putton a wanring pop-up first or a form where you provide addresses ?

    Please Login or Register  to view this content.
    Apologies for the delay, got pulled in to a different project for a while.

    A push button would work just fine..

  4. #4
    Registered User
    Join Date
    06-25-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to create a "send email" event once a field is modified?

    Alright, got all this working. I added a button and all is good... MINUS - The TO and CC fields aren't populating in a new email form.

    I have the data in the TOmail and CCmail cells.

    Any thoughts?

    EDIT:

    I tried changing code to the following:

    Please Login or Register  to view this content.
    And no change..
    Last edited by DatacomGuy; 09-27-2013 at 10:54 PM.

  5. #5
    Registered User
    Join Date
    06-25-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: How to create a "send email" event once a field is modified?

    One more change i want to make and need help with.

    I have a field (E9) that i want to make the subject of the email. I want the field to read "E9" PLUS " MPO Quoted".. So as an example, if cell E9 says "DC1", the email subject would read "DC1 MPO Quoted". I have changed subject code to ".Subject = Range("E9").Text" but need to know how to add the " MPO Quoted" to it.

    Secondly.. If this field is left empty, i want it to do its own subject line of "MPO Quoted" by itself.

    How can i accomplish?

+ 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. VBA coding to automatic allow "a program is trying to send an email"
    By wfm007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 06:27 AM
  2. Macro "send to email" for specific spreadsheet section
    By thomasp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2013, 08:41 AM
  3. Can you set a "trigger" in excel to send an email?
    By Debbi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2006, 11:30 AM
  4. Replies: 2
    Last Post: 07-11-2005, 12:05 PM
  5. [SOLVED] Am not getting "send" option to email Excel sheet
    By Pegin Excel in forum Excel General
    Replies: 0
    Last Post: 02-02-2005, 05:06 PM

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