I need to send out a reminder email every other Wednesday, so I thought a simple reoccurring email would do the trick. I then learned that Outlook 2010 does not have such a feature without an add-on. I found and followed this tutorial from Microsoft. I used the following code in a custom task form:
Then I create a new task with the newly published form and set it to reoccur. The task appears in my Task List. I mark it as complete, but nothing happens. I am a rookie at VBA and have no idea how to fix the code to do what I am looking for. Could someone please assist me in this?
Sub Item_PropertyChange(ByVal Name) Select Case Name Case "Status" if Item.Status = 2 then '2 = Completed Set NewItem = Application.CreateItem(0) NewItem.To = "change to the email I want to send email@example.com; firstname.lastname@example.org" NewItem.Recipients.ResolveAll NewItem.Subject = "This is the message subject text" NewItem.Body = "This is text that will appear in the body of the message." NewItem.Display NewItem.Send End IF End Select End Sub