Automating an E-mail

[Scott Christopher]

I have a file that is required to be sent to the same person every
Monday/Wednesday/Friday. Currently, I have to remember to send this,
which is usually ok, but if I'm not at my office, it doesn't get sent.

Is it possible to automate this process where if Outlook is running,
it can automatically send this file at the same time on each of these
days, just like a scheduled task?

I am running Windows XP and Office XP.

Any help with this would be greatly appreciated. If you do have an
idea, if you can, please e-mail to me.

Thanks,

Scott Christopher
MIS Manager / System Administrator
MSD, Inc.

(e-mail address removed)

 

[Michael Bednarek]

I have a file that is required to be sent to the same person every
Monday/Wednesday/Friday. Currently, I have to remember to send this,
which is usually ok, but if I'm not at my office, it doesn't get sent.

Is it possible to automate this process where if Outlook is running,
it can automatically send this file at the same time on each of these
days, just like a scheduled task?

I am running Windows XP and Office XP.

Any help with this would be greatly appreciated. If you do have an
idea, if you can, please e-mail to me.

(You ask here, you get the answer(s) here.)

Unfortunately, Outlook cannot be invoked with a switch from the command
line that would run a macro (I think), but you can user a command line
mailer and schedule that as required.

For command line mailers, you can use blat
<http://www.interlog.com/~tcharron/blat.html> or write a small .VBS
script. I use the the one published at
<http://mcmbednarek.tripod.com/4dos_files.htm> a lot. (To download
"sendmail.vbs", you have to right-click the link and "Save As..."
sendmail.vbs.) The easiest method to schedule this is probably while
leaving your PC switched on, logged in, and Outlook running. Other
scenarios may be possible.

For your purposes, you need to add something like:
..Attachment.Add(yourFile,olByValue)
where olByValue=1.

 

[Milly Staples [MVP - Outlook]]

See if the information here is of assistance:
http://www.slipstick.com/dev/olforms/skedrpt.htm


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.


After searching google.groups.com and finding not answer:
Scott Christopher <[email protected]> asked:
| I have a file that is required to be sent to the same person every
| Monday/Wednesday/Friday. Currently, I have to remember to send this,
| which is usually ok, but if I'm not at my office, it doesn't get sent.
|
| Is it possible to automate this process where if Outlook is running,
| it can automatically send this file at the same time on each of these
| days, just like a scheduled task?
|
| I am running Windows XP and Office XP.
|
| Any help with this would be greatly appreciated. If you do have an
| idea, if you can, please e-mail to me.
|
| Thanks,
|
| Scott Christopher
| MIS Manager / System Administrator
| MSD, Inc.
|
| (e-mail address removed)