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.

Set email reminder based on excel

Discussion in 'Business Applications' started by bivad, Jun 4, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. bivad

    bivad Thread Starter

    Joined:
    Jun 3, 2012
    Messages:
    2
    hi there,

    I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

    Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

    The list is on excel with expiration date in one of the columns


    thanks
     
  2. Keebellah

    Keebellah Hans Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,342
    Hi, take a look at some of the posts, there are quiet a few that do just that, they may need a little editting for your purpose but...
    Here's a simple module that does just that, all you need to do is wriet a amcro that fills in the blanks
    Code:
    Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
    Dim eSubject As String, Sendto As String, CCto As String, EBody As String
    Dim app As Object, Itm As Variant
    Set app = CreateObject("Outlook.Application")
    Set Itm = app.CreateItem(0)
    
    With Itm
        .Subject = mSubject
        .To = Sendto
        If Not IsMissing(CCto) Then .CC = CCto
        .Body = mMessage
    '     .Attachments.Add (NewFileName1) ' Must be complete path
        .Display ' This property is used when you want
    '    .send
    End With
    Set app = Nothing
    Set Itm = Nothing
    End Function
    
    
    P.S. You forgot to mention the Excel versio you're using
     
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/1055728