+ Reply to Thread
Results 1 to 3 of 3

Send Outlook Mail based on value changes in cell

  1. #1
    Registered User
    Join Date
    10-02-2011
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    19

    Send Outlook Mail based on value changes in cell

    Dear Team,

    I am updating calibration data's on my excel. In that the last calibration date entered on column G and Next due date will update automatically on Column H which is 90 days time period. In column I update for remaining days. I want to send remainder mail to my customer before 10 days( between 1 to 10 days) of expire the next due date.

    For that i had created code for send separate email for each customers. But the mail opening only for the row where i am selecting. First it should check the value on column I where the values between 1 to 10 days and send mail only to that customers.

    Once the mail is sent to customer it should print on column J like Mail sent

    I attached my file here for your reference.

    Kindly do the need full for completing this work.
    Attached Files Attached Files

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,723

    Re: Send Outlook Mail based on value changes in cell

    Cross-posted at: http://www.vbaexpress.com/forum/show...hanges-in-cell
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2301 (Windows 11 22H2 64-bit)
    Posts
    65,652

    Re: Send Outlook Mail based on value changes in cell

    Administrative Note:

    THIS IS YOUR FINAL WARNING. You have been reminded of our cross-posting rule at least three times now - any further infraction may result in your posting rights being terminated here.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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. Create ready-to-send e-mail in Outlook based on dynamic cell values in Excel
    By kjaer88 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-06-2020, 06:42 AM
  2. [SOLVED] Send outlook mail based on a today's date and customer name
    By manieldunk in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-20-2018, 02:04 PM
  3. VBA auto outlook 2016 to send e-mail based off criteria
    By broman5000 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-30-2017, 04:15 PM
  4. [SOLVED] Code to send mail copying from Excel to a new outlook mail.
    By paz1987 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-11-2015, 07:54 AM
  5. Based on Birthdate in excel , Automatically send outlook mail with birthday wishes
    By ajaypal.sp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2015, 08:28 PM
  6. Send e-mail with image on body (.html) on e-mail manager <> outlook
    By mariotnc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2012, 09:28 PM
  7. Filter based on today's date and send mail in outlook
    By kandanuru in forum Excel General
    Replies: 0
    Last Post: 06-15-2012, 04:59 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