I have to send a couple emails every day with an Excel sheet. Annoying.

Does Outlook 2007 have the ability to auto-send emails with attachments on a
given schedule? If yes, where do I start looking for details?

thanks!

Check for message automation plug-ins for Outlook at Slipstick Systems
(www.slipstick.com). There is a plugin for Outlook that performs message
automation. Just remember, much of that stuff is shareware and freeware, so
expect bugs, and make sure the product documentation explains how to remove
the plugin before you install it.

--Dave

"shank" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have to send a couple emails every day with an Excel sheet. Annoying.
>
> Does Outlook 2007 have the ability to auto-send emails with attachments on
> a given schedule? If yes, where do I start looking for details?
>
> thanks!
>

shank wrote:

> I have to send a couple emails every day with an Excel sheet. Annoying.
>
> Does Outlook 2007 have the ability to auto-send emails with attachments on a
> given schedule? If yes, where do I start looking for details?
>
> thanks!

If the attachment is a file that gets replaced or updated every day, why not
use the command line to create an e-mail with that attachment? Just be sure
to leave Outlook running at the time you schedule the event to run that
command in Task Scheduler.

http://office.microsoft.com/en-us/ou...031101033.aspx

Cool idea, but I don't see a way in the command line switches to address the
message. Do you know how to do that?

--Dave

"VanguardLH" <(E-Mail Removed)> wrote in message
news:hib4vm$4n3$(E-Mail Removed)...
> shank wrote:
>
>> I have to send a couple emails every day with an Excel sheet. Annoying.
>>
>> Does Outlook 2007 have the ability to auto-send emails with attachments
>> on a
>> given schedule? If yes, where do I start looking for details?
>>
>> thanks!
>
> If the attachment is a file that gets replaced or updated every day, why
> not
> use the command line to create an e-mail with that attachment? Just be
> sure
> to leave Outlook running at the time you schedule the event to run that
> command in Task Scheduler.
>
> http://office.microsoft.com/en-us/ou...031101033.aspx

Dave Burns wrote:

> VanguardLH wrote ...
>
>> shank wrote:
>>
>>> I have to send a couple emails every day with an Excel sheet. Annoying.
>>> Does Outlook 2007 have the ability to auto-send emails with attachments
>>> on a given schedule? If yes, where do I start looking for details?
>>
>> If the attachment is a file that gets replaced or updated every day, why
>> not use the command line to create an e-mail with that attachment? Just
>> be sure to leave Outlook running at the time you schedule the event to
>> run that command in Task Scheduler.
>>
>> http://office.microsoft.com/en-us/ou...031101033.aspx
>
> Cool idea, but I don't see a way in the command line switches to address the
> message. Do you know how to do that?

I never bothered to use the command-line options to schedule canned e-mail
sends. My guess is that you would create an e-mail that listed your
recipients (since they're going to be the same for this repeatedly sent
e-mail) and then save it as a .msg file. Then use the /f switch to specify
using that .msg file as the template and the /a switch to specify what file
to attach to that e-mail.

Of course, there is the /m switch which says it specifies emailname. I do
recall that some of the switches won't work with each other so you have to
experiment to see if you can use the /m switch to specify the recipient, the
/f switch to provide a template for what is in the e-mail's body that you
want to send, and the /a switch to attach a file to that e-mail.