1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

create email reminder for outlook from excel

Discussion in 'Business Applications' started by sanjayvalanju, Jan 31, 2020.

Thread Status:
Not open for further replies.
  1. sanjayvalanju

    sanjayvalanju Thread Starter

    Joined:
    Jan 30, 2020
    Messages:
    2
    Hi there,

    I want a hele regarding email reminder for ourlook from excel..
    I want to send reminder notification to internal group of ppl. there are multiple sheets in a workbook. we have to send email reminder before 3 and 0 days. data is having repayment schedule. we have to capture due date and repayment principal amount and also there is different set of dates for repayment of interest we have to send email notification for them as well. My current data is from A2 : J 11 (and it can be incremental in future). My principal amount is in column "D" , principal amount due date is in column "E" and principal amount reminder is in column "F" here i have given networkdays formula to give reminder before 3 and 0 days we have set reminder on column "F". where as interest amount is in column "G" and interest amount due date is in colun "H" and interest amount reminder is in column "I", in column J i have given bank name which is constant for one sheet. Now i want to set email notification based on column "F" for principal amount and Column "I" for interest amount. Email subject should be "payment reminder", and email body should contain due date, principal amount and interest amount and bank name. email should go to multiple persons. i am attaching file for better understanding.
    Many thanks in advance for your help.
     

    Attached Files:

  2. sanjayvalanju

    sanjayvalanju Thread Starter

    Joined:
    Jan 30, 2020
    Messages:
    2
    Hi there,
    can anyone help me with vba code?
    I want a help regarding email reminder for ourlook from excel..
    I want to send reminder notification to internal group of ppl. there are multiple sheets in a workbook. we have to send email reminder before 3 and 0 days. data is having repayment schedule. we have to capture due date and repayment principal amount and also there is different set of dates for repayment of interest we have to send email notification for them as well. My current data is from A2 : J 11 (and it can be incremental in future). My principal amount is in column "D" , principal amount due date is in column "E" and principal amount reminder is in column "F" here i have given networkdays formula to give reminder before 3 and 0 days we have set reminder on column "F". where as interest amount is in column "G" and interest amount due date is in colun "H" and interest amount reminder is in column "I", in column J i have given bank name which is constant for one sheet. Now i want to set email notification based on column "F" for principal amount and Column "I" for interest amount. Email subject should be "payment reminder", and email body should contain due date, principal amount and interest amount and bank name. email should go to multiple persons.
    Many thanks in advance for your help.
     
  3. cwwozniak

    cwwozniak Trusted Advisor Spam Fighter

    Joined:
    Nov 28, 2005
    Messages:
    64,624
    First Name:
    Chuck
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1239547

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice