Scheduling a macro in outlook 2000

B

Brian

I am trying to schedule a macro to run everyday at a given
time, which creates a new email, attaches an excel file
and sends it via the internet to another PC, so that there
is no input required from a user, i.e. it happens
automatically.

I can create the email, attach the file and send it, but I
cannot schedule it within Outlook. Also when I run the
code from Excel, where I can schedule it, only a shortcut
is attached to the email.

I am using Outlook 2000 (no service release).

Has anyone done this before? Can you help?

Regards

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top