![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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: 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 | Thread Starter | Forum | Replies | Last Post |
Reminder Sound | sat | Outlook - General Queries | 2 | June 30th 06 11:18 PM |
Reminder | JuanPabloGallardo | Outlook - Calandaring | 0 | April 26th 06 10:29 PM |
Birthday Reminder | Ron777 | Outlook - Calandaring | 1 | April 26th 06 04:10 PM |
Reminder NOT STICKING | Mary G. | Outlook - Calandaring | 0 | April 25th 06 10:48 PM |
Reminder | deke | Outlook - Calandaring | 2 | April 24th 06 08:17 AM |