I am wondering how I can set an appointment in Outlook, using VBA, which will
always have the same start time, but the date will vary.

I can get the date to set using:

objAppt.Subject = "New Hire Consult with " & strEmp
objAppt.Start = dteDate
objAppt.Save

But, when I add the time on there (I have tried several ways, including " &
"#08:00#"; or "#" & dteDate & " " & dteTime & "#", among others.) So, I can
get a 'hard coded' time/date... but the date will be recurring it depends on
the users input. ; it's okay for the time to be a standard.

Oh, and also - how can I make the calendar update immediately? I have to
exit out of Outlook once or twice before the update is made.

Hope that made sense.

Thanks!

Am Sun, 21 Aug 2005 23:44:36 -0700 schrieb TRM:

Do you ask how to add a date *and* a time? Please try this:

Appointment.Start = Date & " 10:35:00"
Appointment.Save

This also should update your calendar immediately.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

> I am wondering how I can set an appointment in Outlook, using VBA,
which will
> always have the same start time, but the date will vary.
>
> I can get the date to set using:
>
> objAppt.Subject = "New Hire Consult with " & strEmp
> objAppt.Start = dteDate
> objAppt.Save
>
> But, when I add the time on there (I have tried several ways,
including " &
> "#08:00#"; or "#" & dteDate & " " & dteTime & "#", among others.) So,
I can
> get a 'hard coded' time/date... but the date will be recurring it
depends on
> the users input. ; it's okay for the time to be a standard.
>
> Oh, and also - how can I make the calendar update immediately? I have
to
> exit out of Outlook once or twice before the update is made.
>
> Hope that made sense.
>
> Thanks!

So simple - thanks! I guess I hadn't tried without the number signs.


"Michael Bauer" wrote:

> Am Sun, 21 Aug 2005 23:44:36 -0700 schrieb TRM:
>
> Do you ask how to add a date *and* a time? Please try this:
>
> Appointment.Start = Date & " 10:35:00"
> Appointment.Save
>
> This also should update your calendar immediately.
>
> --
> Viele Gruesse / Best regards
> Michael Bauer - MVP Outlook
>
> > I am wondering how I can set an appointment in Outlook, using VBA,
> which will
> > always have the same start time, but the date will vary.
> >
> > I can get the date to set using:
> >
> > objAppt.Subject = "New Hire Consult with " & strEmp
> > objAppt.Start = dteDate
> > objAppt.Save
> >
> > But, when I add the time on there (I have tried several ways,
> including " &
> > "#08:00#"; or "#" & dteDate & " " & dteTime & "#", among others.) So,
> I can
> > get a 'hard coded' time/date... but the date will be recurring it
> depends on
> > the users input. ; it's okay for the time to be a standard.
> >
> > Oh, and also - how can I make the calendar update immediately? I have
> to
> > exit out of Outlook once or twice before the update is made.
> >
> > Hope that made sense.
> >
> > Thanks!
>