Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Outlook Macro for Opening Reuters, Opening Excel File, Send Email (http://www.outlookbanter.com/outlook-vba/76902-outlook-macro-opening-reuters-opening.html)

Tsp245 August 13th 08 06:29 PM

Outlook Macro for Opening Reuters, Opening Excel File, Send Email
 
Hello,
I am trying to create a macro that will perform the following in order:
1) Open Reuters
2) Open an Excel File to update
3) Close the Excel File and Send to an individual a scheduled basis (3 times
daily)

Would I have to keep my outlook on at all times to run the macro, and is
there a way to do this without creating a daily job on the server?
--
Regards,

Tsp245

Michael Bauer [MVP - Outlook] August 13th 08 08:27 PM

Outlook Macro for Opening Reuters, Opening Excel File, Send Email
 


If you want to run the code within Outlook, then yes, Outlook must run all
the time.

Here's a sample for how to use a task reminder to run your code at a
scheduled time:

http://www.vboffice.net/sample.html?...cmd=showite m

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Wed, 13 Aug 2008 10:29:01 -0700 schrieb Tsp245:

Hello,
I am trying to create a macro that will perform the following in order:
1) Open Reuters
2) Open an Excel File to update
3) Close the Excel File and Send to an individual a scheduled basis (3

times
daily)

Would I have to keep my outlook on at all times to run the macro, and is
there a way to do this without creating a daily job on the server?



All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com