![]() |
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
|
|||
|
|||
![]()
Option Compare Database
Option Explicit Function AddOutLookTask() Dim OutlookApp As Outlook.Application Dim OutlookTask As Outlook.TaskItem Set OutlookApp = CreateObject("Outlook.Application") Set OutlookTask = OutlookApp.CreateItem(olTaskItem) With OutlookTask .Subject = "Date Case Began: " & [Forms]![frmERLR_Main]! [DateCaseBegin] & " Action Type: " & [Forms]![frmERLR_Main]! [ActionType] & " - " & [Forms]![frmERLR_Main]![ERLRAgencyName] & " - Management POC: " & [Forms]![frmERLR_Main]![ManagementPOC] .Body = "Issue: " & [Forms]![frmERLR_Main]![ERLRIssue] & " - Recommendation: " & [Forms]![frmERLR_Main]![ERLRRec] .ReminderSet = True 'Remind .ReminderTime = [Forms]![frmReminder]![StartTime] 'Start Date .StartDate = [Forms]![frmReminder]![StartDateE] 'Due . .DueDate = [Forms]![frmReminder]![StartDateE] .ReminderPlaySound = True 'Modify path. .ReminderSoundFile = "C:\WINNT\Media\Ding.wav" .Save End With End Function When I call the function to add a task to outlook for the same day as today and set the reminder time, it puts Sat 12/30/1899 in the reminder date but the time is correct. When I call the function for a date in the future, it gets the reminder date correct, but defualts the time to 08:00AM. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding formula field to custom task form | SHC | Outlook - Using Forms | 1 | March 25th 07 09:12 PM |
Adding a document shortcut to an Outlook task | LurfysMa | Outlook - General Queries | 0 | March 21st 07 04:27 PM |
Adding Contacts to a Task in Oulook 2007 | O | Outlook - Using Contacts | 1 | February 13th 07 04:48 PM |
Adding an Outlook task from Access | Blogd_Node | Outlook and VBA | 6 | June 7th 06 04:33 PM |
Adding User Defined Field to Task Form | Gordon Staley | Outlook - Using Forms | 4 | May 2nd 06 08:24 PM |