|
| 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
April 8th 09, 04:46 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Set appointment time
I have created a macro that schedules an appointment for a follow up based on
the current date and time. The follow up has to be scheduled for the next day at 8 a.m. I'm not sure about the best way to do that. I can only get it to except a specific date and time and not a variable date (one dat from the current date) and a specific time. Here is what I have that schedules a follow up one day from the current date two hours ahead. olAppt.Start = Now() + (1#) + (2# / 24#) But if it is Thursday then I need it to schedule it one day from the current date at 8 a.m. I've tried something that looks like this, and slight variations, but it doesn't work. The only part that doesn't work is the #8:00:00# AM part. If Weekday(dteNextDate) = 5 Then olAppt.Start = Now() + (1#) & #8:00:00 AM# Any suggestions? Is it even possible? 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to set an appointment day but no time (nor all day) | Dave Sutton | Outlook - Calandaring | 1 | August 13th 07 07:21 PM |
| Outlook 2007: appointment with end time before start time | PeterA | Outlook - Calandaring | 0 | April 24th 07 12:42 PM |
| want appointment start time to show in calendar, but not end time | Arlene | Outlook - Calandaring | 0 | October 18th 06 03:53 PM |
| Allow Time Zone Changes Without Changing Calendar Appointment Time | TE | Outlook - Calandaring | 1 | June 19th 06 01:42 AM |
| Daylight Savings Time Changes Appointment Time | DCEXEC | Outlook - Calandaring | 5 | April 5th 06 10:31 PM |
Threaded Mode