asked on

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

ASKER CERTIFIED SOLUTION

M A

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aparna Gannavarapu

ASKER

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

Aparna Gannavarapu

ASKER

.HTMLBody *

tell me how to add CC or BCC

SOLUTION