+ Reply to Thread
Results 1 to 4 of 4

Send emails from excel spreadsheet when expiration date approaches

  1. #1
    Registered User
    Join Date
    01-25-2016
    Location
    Montenegro
    MS-Off Ver
    2013
    Posts
    8

    Question Send emails from excel spreadsheet when expiration date approaches

    Hello everyone,

    I am quite new to excel but have lots of interest to work things out about this topic as it is very interesting to my field.

    I would need the excel to notify me via email as a person responsible, but also my contract manager when certain contract is closing expiration (for renewal procedure). So once a column Termination notice is activated, id est when a date indicated there comes, just an email with subject renewal and body which would be a text of column Name - so we know what contract it is. Obviously, if this could be done on a regular basis, without me having to sit in the file all the time. Hope I don't ask way too much.

    Any help would be greatly appreciated...

    Thanks Slavica
    Attached Files Attached Files
    Last edited by amaranthum; 02-23-2017 at 04:57 AM.

  2. #2
    Registered User
    Join Date
    01-25-2016
    Location
    Montenegro
    MS-Off Ver
    2013
    Posts
    8

    Re: Send emails from excel spreadsheet when expiration date approaches

    Further to the above, I tried everything I came across throughout the forum but can not seem to get the things right.

    Anyone who can help here please?

  3. #3
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Send emails from excel spreadsheet when expiration date approaches

    I'd love to see what you've tried so far but that file attached above doesn't have any code in it.

    Firstly, start here for a good general overview of VBA: http://www.excelforum.com/excel-prog...materials.html

    Then look here for code designed for sending emails (from outlook, if your mail client is something else like Notes let me know and I'll find you a page on Notes emails with VBA): http://www.rondebruin.nl/win/s1/outlook/mail.htm

  4. #4
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Send emails from excel spreadsheet when expiration date approaches

    oops, double post

+ 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. Replies: 1
    Last Post: 01-05-2017, 08:33 AM
  2. Replies: 4
    Last Post: 12-24-2015, 12:02 PM
  3. Excel vba to auto-send customer emails (duplicate emails issue)
    By nadz84 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-29-2015, 10:08 AM
  4. Send Emails once expiry date is reached, and generate report based on emails sent
    By demonicscorpion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 05:36 AM
  5. Send excel sheet to multiple emails according to the date and time set
    By Nadrose in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2014, 11:09 PM
  6. macro to automatically send email when due date approaches in XL spreadsheet.
    By PTSO in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-04-2014, 06:26 PM
  7. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 PM

Tags for this Thread

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