Automatically sending an email with Outlook macros

[Janice]

Hello,

Can anybody help me out? I am trying to have an email sent every Friday at
a specific time. My theory is to use this code, but can't figure out why
it doesn't work:

Dim MyTime
MyTime = Time ' Return current system time.
clock
If "9:40AM" Then

SendMessage
Else
End If

As of right now I have to run the macro to send the message. I want Outlook
to be able to look at the internal clock and when it reaches the specified
time, send the message.
any other approach or help with this would be appreciated.
thanks
Janice

[guanha]

Do you want to create a scheduled Task ?

I assume the following:

You want the scheduler to run on the outlook client
You want the task to be executed once every day

You then need:

To have your computer running with the outlook client open
every day at that given time

One simple solution to this (that might work) is something like:

1. Create a calendar/meeting request that executes every day at a given time
(recurrence)
2. Code the open event in this (now custom) outlook form that sends your
mail and then closes itself.

You need to familiarize yourself with:

The outlook form, vbscript (specifically the open event) and outlook VBA

guanha

"Janice" <vb.@127.0.0.1> wrote:
>
>Hello,
>
>Can anybody help me out? I am trying to have an email sent every Friday
at
>a specific time. My theory is to use this code, but can't figure out why
>it doesn't work:
>
> Dim MyTime
> MyTime = Time ' Return current system time.
> clock
> If "9:40AM" Then
>
> SendMessage
> Else
> End If
>
>As of right now I have to run the macro to send the message. I want Outlook
>to be able to look at the internal clock and when it reaches the specified
>time, send the message.
>any other approach or help with this would be appreciated.
>thanks
>Janice