Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Email (2003)

    I am using an excel spreadsheet to list service contracts and realted info. One of the cells in each row is the erpiration date of the contract. Is it possible to send an automatic email to someone 90 days before this date and remind them their contract is set to expire?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatic Email (2003)

    Would you like the e-mails to be sent without user intervention, or would you like an e-mail to be generated automatically then displayed on screen so that the user can edit it if desired, then send it (or not)?

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Email (2003)

    I would like it to be without user intervention using a generic email with the name of the contract and the expiration date in the body.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatic Email (2003)

    I have attached a sample workbook. The code is in the Workbook_Open event procedure in the ThisWorkbook module.

    Notes:
    1) You will have to study the code and adapt it to your purposes.
    2) You will need to enable macros.
    3) The code uses Outlook.
    4) This version displays the e-mails instead of sending them, so that you can check whether the e-mails are generated correctly. When you're ready to test sending, comment out the line
    objMail.Display
    and uncomment the line
    objMail.Send
    5) You will probably run into Outlook security. You'll find workarounds in <post:=488,173>post 488,173</post:>; the free utility ClickYes is the easiest one.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •