+ Reply to Thread
Results 1 to 3 of 3

VBA code to send email automatically to ownself of expiry of license/insurance/ others

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Post VBA code to send email automatically to ownself of expiry of license/insurance/ others

    Hi All,

    Greetings,

    I have this excel sheet of my co-workers' visa expiry / license expiry / insurance expiry etc. I want get reminded of myself through email 15 days before any docs' expiry for different people of different documents.

    Thanks a lot for support

    Suraj Shrestha

    Sno
    Name
    Visa Expiry
    License Expiry
    EID Expiry
    Insurance Expiry
    Vehicle Expiry
    Reminder Sent on

  2. #2
    Registered User
    Join Date
    04-03-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: VBA code to send email automatically to ownself of expiry of license/insurance/ others

    Hi All,

    Appreciate your support

    Sorry for being pushy

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,282

    Re: VBA code to send email automatically to ownself of expiry of license/insurance/ others

    Post example workbook with desensitized data so we can check your setup and answer accordingly.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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 Code To Display Email Instead Of Automatically Send
    By alulla in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-28-2013, 01:59 PM
  2. Send an auto email if the expiry date is 1 month away
    By jy7788 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2013, 11:29 AM
  3. Replies: 5
    Last Post: 02-22-2013, 02:00 AM
  4. send email automaticaly 30 days before expiry
    By sunil.lobo123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-02-2012, 05:23 AM
  5. modify the VBA code to automatically send an email
    By kachuen2006 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2012, 02:46 AM
  6. [SOLVED] VBA code - automatically open outlook to send email
    By LindaABH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:44 AM
  7. excel code that will send mail to 2 email ID before 30 days of visa date expiry
    By rinadimayuga in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2012, 04:24 AM
  8. Replies: 1
    Last Post: 05-19-2012, 10:33 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