2

I want to send out an updated excel sheet - that I update on Friday to send - at the beginning of the week (the following Monday).

I'm not sure how I can:

  1. Schedule in Outlook to have a recurring email be sent out on Monday at 9 AM

  2. Is there a way for my outlook to grab my updated excel from some specified folder on my computer and send it out?

StayPuft
  • 125
  • 1
  • 1
  • 13
  • I'm not sure about Outlook, but you can create an automated task on Windows Task Scheduler to send an email every Monday at 9 AM as you need and you can also specify the path to the attachment, so it'll be updated when the email is sent... – DarkAjax Jun 12 '14 at 21:13
  • I can think of two ways. One is already provided by @darkajax but here is a [sample link on how to do it](http://stackoverflow.com/questions/10211250/excel-vba-email-does-not-send-when-computer-is-locked/10212810#10212810) using VBScript. The screen shots are out-dated but I think you can figure it out. Another is using Outlook Reminder to trigger your Email sending code. [Example of such can be found here](http://stackoverflow.com/questions/21179750/how-to-call-outlook-procedure-using-vbscript-for-use-in-task-scheduler). – L42 Jun 13 '14 at 02:02
  • Task Scheduler sounds like it would be easier (???) – StayPuft Jun 13 '14 at 13:24

2 Answers2

7

If you want to try it with the Task Scheduler, you should do this:

  • Open the Task Scheduler
  • Select Create Task:

  • Go to the Actions tab:

  • Select Send an e-mail:

  • After configuring your action, go to the Trigger tab:

  • Choose On a schedule and set the task to run weekly on Mondays as you need:

DarkAjax
  • 15,955
  • 11
  • 53
  • 65
  • That looks like exactly what I'm looking for! Just a question though - for the attachment - will it always send out the same attachment on the given weekly basis? – StayPuft Jun 13 '14 at 13:56
  • 1
    @StayPuft It'll send the attachment you select as long as it exists (otherwise it'll send an email with no attachment). Also in case you're worried, it's good to point out that the file sent will be on it's current state, so if you updated it'll be the most updated version, not something like the file as it was when you created the task. – DarkAjax Jun 13 '14 at 14:14
-1

The bad thing about this is that you need an SMTP server to work, it cannot be done through Outlook.

Juan Carlos Moreno
  • 1
  • 1
  • 1
    Not exactly, as you can use Outlook's SMTP Server to send email, [see](https://www.lifewire.com/what-are-the-outlook-com-smtp-server-settings-1170671) – joaumg Dec 09 '16 at 18:45