|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
August 13th 08, 07:29 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
| Ads |
|
#2
August 13th 08, 09:27 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| AUTO RUN A MACRO ON OPENING OUTLOOK | middoabs | Outlook and VBA | 5 | May 23rd 13 07:16 AM |
| Insert a ftr or macro into email saved to .doc w/o opening doc fi | Marceepoo | Outlook and VBA | 1 | June 1st 08 08:24 PM |
| OFT File keeps opening as attachment in email. | Adrian | Outlook - Using Forms | 1 | December 15th 06 02:38 PM |
| Emailed Excel File not opening on one PC | MarcusD | Outlook - Installation | 1 | November 29th 06 10:12 AM |
| Send a reply on opening an email | CarlSprake | Outlook and VBA | 1 | January 19th 06 08:41 AM |
Linear Mode
