+ Reply to Thread
Results 1 to 2 of 2

Sending emails via outlook when a value in excel 2007 is changed

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-12-2008
    Location
    Doha-Qatar
    MS-Off Ver
    Excel 2007
    Posts
    137

    Sending emails via outlook when a value in excel 2007 is changed

    Hello Friends,

    Please help me on this.
    I pay my clients in advance for items which they will supply in future and for this I have prepared an excel sheet to keep track on these payments and to ensure that the items are received by the end users in my organization.
    In the excel sheet I have the following columns:
    1- Vendor name
    2- Payment Date
    3- Payment Number
    4- Amount
    5- Today’s Date
    6- Days Elapsed
    7- Requested by ( End user)
    8- Email address of the end user
    My question, Is it possible to make excel automatically sending a notification to the end users specified email ID when the days elapsed is exceeding 30 days along with details of the payment I have already made?

    I would like to see the message as following:

    Dear (Name of the end user),

    Please confirm receiving of the items from the bellow mentioned suppliers

    Vendor Name Payment Date Payment No Amount Today’s Date Days Elapsed
    BBBB 7-Aug-08 9001 500.00 8-Sep-08 32

    I have attached a sample for your kind review

    Many Thanks Simon for your advise, i have changed the tiltle

    Thank you & best regards
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    http://www.rondebruin.nl/mail/change.htm
    and
    http://www.rondebruin.nl/sendmail.htm

+ 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. Integration of Excel 2007 and Visio 2007
    By wilro85 in forum Excel General
    Replies: 1
    Last Post: 07-03-2008, 12:40 PM
  2. Excel 2007 : DialogSheet in Excel 2007
    By hashem_te in forum Excel General
    Replies: 2
    Last Post: 06-02-2008, 04:56 AM
  3. Sending Emails From Excel 2003
    By hagadol in forum Excel General
    Replies: 2
    Last Post: 05-28-2008, 08:12 AM
  4. Excel 2007 and linked in charts to Powerpoint 2007
    By Sionos in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-14-2008, 12:26 PM
  5. Conflict between Excel and Outlook
    By ilee1 in forum Excel General
    Replies: 0
    Last Post: 10-16-2007, 10:49 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