Recurring emails automatically

i want to send a same email monthly to a set of team members. but don't want to open excel to run the macros.

for example the order due date is on 15th of every month, a reminder should be sent 2 days ahead of the due date aurecurr
Aparna GannavarapuAsked:
Who is Participating?
 
MAS (MVE)Connect With a Mentor Technical Department HeadCommented:
This expert suggested creating a Gigs project.
HI Aparna,
This is a sample excel file I created for sending reminder for renewals.
You can use the same for yours.
Please let me know if you have doubt.

Thanks
MAS
Sample.xlsm
1
 
Aparna GannavarapuAuthor Commented:
thanks for the reply,  i have written a VBS code for sending emails, which i thought of connecting it with task scheduler, but i am not able to add CC in this code. it is throwing me error. Let me know what is the issue in the code.

Dim olkApp
Dim olkSes
Dim olkMsg
Set olkApp = CreateObject("Outlook.Application")
Set olkSes = olkApp.GetNamespace("MAPI")
olkSes.Logon olkApp.DefaultProfileName
Set olkMsg = olkApp.CreateItem(0)
With olkMsg
   
    .Recipients.Add "to email"
    .Recipients.ResolveAll
   
    .Subject = "Reminder Email"
   
    Html.Body = "here i put my message using HTML"
        .Send
End With
Set olkMsg = Nothing
olkSes.Logoff
Set olkSes = Nothing
Set olkApp = Nothing
0
 
Aparna GannavarapuAuthor Commented:
.HTMLBody *

tell me how to add CC or BCC
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
abbas abdullaConnect With a Mentor Commented:
Hi,
Try :

.CC= "someone@company.com"
.BCC= "someone@company.com"
0
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Why not create a recurring appointment with notification/reminder 2 days prior?

Attach the file or a hyperlink to a shared directory to the appointment and the attendees will be able to open the file.
0
 
MAS (MVE)Technical Department HeadCommented:
Enough information to confirm answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.