Tech Support Guy banner
Status
Not open for further replies.

Set email reminder based on excel

1K views 1 reply 2 participants last post by  Keebellah 
#1 ·
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 ·
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
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top