Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
How do I via vba write code that will automatically put in a reminder two days out when an email is sent out from excel? Example. I have an excel sheet that checks for corrections of a form, once I have made the corrections via excel userform, I have a commandbutton (email) that opens an outlook message, pastes my comments, inserts email addresses etc. What I would also like to do is write code that creates a reminder in outlook that will remind me to email after a couple of days. Here is the code that I use to send the message from excel of which I got from this site, many thanks: Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail ..to = " ..CC = " " ..BCC = " " ..Subject = "OER for " & Worksheets("Correction_Sheet").Range("b3") & ", Thru date " & Worksheets("Correction_Sheet").Range("e5") & "." ..Body = Focus ..Display Application.Wait (Now + TimeValue("0:00:04")) Application.SendKeys "%esf{enter}" End With Set OutMail = OutApp.CreateItem(0) Set OutApp = Nothing Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can Excel trigger Outlook reminder? | Excel Worksheet Functions | |||
Does excel have a reminder function like outlook does? | Excel Worksheet Functions | |||
Can a date in excel be linked with outlook to serve as a reminder | Excel Worksheet Functions | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
make appointment in outlook and send email reminder - all data in excel 2000 | Excel Programming |