Scheduling a macro in outlook 2000

I am trying to schedule a macro to run everyday at a given 
time, which creates a new email, attaches an excel file 
and sends it via the internet to another PC, so that there 
is no input required from a user, i.e. it happens 
automatically.

I can create the email, attach the file and send it, but I 
cannot schedule it within Outlook.  Also when I run the 
code from Excel, where I can schedule it, only a shortcut 
is attached to the email.

I am using Outlook 2000 (no service release).

Has anyone done this before?  Can you help?

Regards

Brian
0
anonymous (74723)
1/7/2004 7:39:43 PM
outlook 87535 articles. 11 followers. Follow

1 Replies
715 Views

Similar Articles

[PageSpeed] 22

See if the information on the following page helps:

http://www.slipstick.com/dev/olforms/skedrpt.htm

-- 
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In news:032501c3d555$ffe0b9c0$a301280a@phx.gbl,
Brian wrote:

> I am trying to schedule a macro to run everyday at a given
> time, which creates a new email, attaches an excel file
> and sends it via the internet to another PC, so that there
> is no input required from a user, i.e. it happens
> automatically.
>
> I can create the email, attach the file and send it, but I
> cannot schedule it within Outlook.  Also when I run the
> code from Excel, where I can schedule it, only a shortcut
> is attached to the email.
>
> I am using Outlook 2000 (no service release).
>
> Has anyone done this before?  Can you help?
>
> Regards
>
> Brian


0
1/8/2004 3:21:49 AM
Reply:

Similar Artilces:

RM Error: General failure in scheduling engine
Good day! It seems my installation of CRM 3.0 was ok. I did not come across any errors, but I have landed with this annoying error; CRM Error: General failure in scheduling engine. Is crops up when viewing the Service Calendar and any acvtivity involving a calendar function. Is there anyone who could shine some light on this problem, or have a cure? Any help would be welcome. Ralph Lehmann Hi Ralph, I ain´t got this failure yet, but I got also a problem with some kind of calendar (creating a new item from within outlook won´t work) and so I searched around a bit. maybe this...

when I minimise outlook it closes and I have to reopen.
when I minimise outlook it closes and I have to reopen. How do I rectify? Aeroblique wrote: > when I minimise outlook it closes and I have to reopen. How do I rectify? Stop clicking on the "X" exit button in the titlebar of Outlook's window. Click on the *minimize* button in the titlebar. The option has Outlook minimize to a tray icon, not to override the exit function. If you have configured Outlook to minimize to a tray icon and are indeed minimizing Outlook instead of exiting it but don't see the tray icon then maybe you configured the Windows taskbar t...

Outlook will not connect to ISP consistently
Keep getting error message 0x800xxx0f; MS says to download SP1, but it will not download. Earthlink says it's a MS download problem. Please help or advise where I can call and get help. ...

Excel 2000
How do you do superscripts within a cell with other text? Example: Young® (make the ® superscript) If you do it a lot, you may want to look at John Walkenbach's addin: http://j-walk.com/ss/excel/files/supersub.htm L Young wrote: > > How do you do superscripts within a cell with other text? > Example: > Young® (make the ® superscript) -- Dave Peterson ...

Outlook client doesn't work
Hello, I've installed the outlook client for CRM 3.0 in my pc, but when I open outlook the system give me that I have to update my outlook. I have a Office 2003 SP2 in Win XP. Someone knows the problem ? MAX Does the CRM menu and funcationality works ? OR u unable to open the outlook ? Can u check the event log ? was there any problem or error while installation? Does the CRM menu and funcationality works ? OR u unable to open the outlook ? Can u check the event log ? was there any problem or error while installation? On 22 Mag, 13:51, whatels...@gmail.com wrote: > Does the C...

Outlook Fonts #3
Hi, Is there a way for me to push out a registry or file update to set all Outlook 2003 users to use a particular font? I can't seem to find it in the registry! Thanks! ...

Macro Action Fails on Duplicate Record
I have a form with a subform whose visibile property is set to no. I have a macro that runs when a choice is made in a combo box that sets the visible property of the subform to yes when the selection=2. The macro sets the visible property of the subform to no when the selection does not =2. This is how I have the macro: Condition: [Appearance]=2 Action:Set Value Item: [Forms]![Appearance Request Basic]![OffSiteApp].[Form].[Detail].[Visible] Expression: True Condition:... Action:StopMacro Condition:(this I left blank) Action: SetValue Item:[Forms]![Appearance Request Basic]![OffSiteApp...

How do I convert my e-mail from Outlook Express to Outlook?
my e-mail is set up in Outlook Express 6 but I want to use Office Outlook 97. When I try to set up Outllook it asks for a "postoffice". Where do I enter my e-mail address and server information? LindaG wrote: > my e-mail is set up in Outlook Express 6 but I want to use Office > Outlook > 97. When I try to set up Outllook it asks for a "postoffice". Where > do I enter my e-mail address and server information? You have to add the Internet Mail Service AFAIR - it's a LOOONG time since I used Office 97! ...

Can't view Publisher 2000 file in Publisher 2000
I have Publisher 2000 but recently 2 different people have sent me Publisher 2000 files that I cannot view - I get a message saying it's in a different version. However, both senders advise the files are definitely Publisher 2000. Is it possible that different patches may have made the difference or could it be something else? ...

CRM Client (MS Outlook) with MSDE connecting to CRM3 Server with SQL Server 2005
Hi, I am currently using MSCRM 3 Server with SQL 2000 Enterprise and CRM Client MS Outlook with MSDE. If I upgrade MSCRM server from SQL2000 to SQL2005 Enterprise, is it also need to upgrade MSDE to SQL Express? Any modification and additional task I need to do about MSDE? Thanks very much. Welcome No, do not update the client machines. CRM for outlook runs on MSDE. It's database does not have to be the same version as the main CRM server. If you upgrade MSDE, you risk breaking your CRM for Outlook install. -- Matt Parks MVP - Microsoft CRM "Welcome" <xxxxx...

Not receiving emails from a specific domain
I couldn't find a search term that would show any messages that dealt with this issue so I apologize if this has been asked and answered already. I moderate a website that sends me messages when I receive a new PM, or a reply to a message I've posted in. I've received these forever. All of a sudden I stopped receiving them. I contacted the administrator of the website who assured me that everything was working properly on the server end. I double checked all settings in my website account profile and everything is set properly there. I contacted my ISP to find out if the do...

Bypassing macro warning messagebox
A macro-containing workbook that I have prepared will be used by several other colleagues. I think the message box that appears upon opening the workbook is likely to throw some of them off. Instead of asking them to change their security settings, is there a way to disable this messagebox? I hope not, or it would be rather redundant wouldn't it(?). -- Regards; Rob ------------------------------------------------------------------------ "K. Georgiadis" <anonymous@discussions.microsoft.com> wrote in message news:18b5401c44b73$e012b0a0$a501280a@phx.gbl... > A macro...

How do I read and refreshes the information from the text file into an EXCEL SHEET,every time when I run macro
Hi Guys, Thanks for information. But I still need some more info about the problem. Actually I want that every time when I run the macro, it refreshes the information from the text file, from the following path (d:\Sql\Documents\Amit\log.txt) and display its contents on the Excel sheet. What steps I should done via MACRO in order to perform that operation? Best Regards Amit. Why not just macro-record your manual process ? --- Message posted from http://www.ExcelForum.com/ ...

MS Word 2000 compatibility with Windows 7
I have recently upgraded to Windows 7 (64-bit) Home Premium from Vista Home Premium. After a week or so, Word 2000 has stopped functioning. Program opens, but there is no cursor, and Task Manager says Word is not responding. I cannot open any document created by Word 2000. Is my only option to upgrade to Word 2007, and spend even more money? See http://www.gmayor.com/what_to_do_when_word_crashes.htm then http://word.mvps.org/FAQs/AppErrors/ProblemsStartingWord.htm or http://support.microsoft.com/kb/921541 -- <>>< ><<> ><<> <>>...

Problem with Outlook Express
I have suddenly started to experience a problem with Outlook Express. If I receive an e-mail with an attachment I get the following message and the attachment won't open - "OE removed access to the following unsafe attachments in your mail". Any ideas why this should suddenly start happening? ...

Do Until Macro
Hello I would like to write a "Do Until" macro that will search for the word "Sub-total" and after finding it. move 7 columns over, then select the next four cells to the right and apply a certain border to those cells. After that, I would like that entire row formatted with Bold. I would want to repeat these steps until it comes to the word Summary. For example find subtotal (which in this case is in cell B10), then move over 7 columns to cell I10, select I10:L10, then apply formatting to those cells. after that select row 10 and apply bold format. ...

scheduling meeting
Hello, We are finally switching over and using Outlook to schedule meetings. Our secretaries will be able to schedule meetings for us. If a secretary schedules a meeting on my behalf, the meeting entry automatically gets put into my calendar. I was wondering if there was a way to receive a notification that the meeting was scheduled. Otherwise, they could schedule meetings on my behalf and I might not ever know it. Thanks. Dan ...

Can not customize Outlook today
We have installed outlook 2000 on everyone's pc. We do not use exchange server. We are using Ipswitch's IMail server. When a user clicks on Customize Outlook Today it does not go to any screen that allows for customization. Nothing happens. Does this feature need to be turned on somewhere or does it have to have Exchange Server to work? Thanks in advance, Paul Ivaska The following MSKB article provides the fix for this issue. OL2000: You Cannot Customize Outlook Today After You Install Critical Update 813489 for Internet Explorer: http://support.microsoft.com/default.aspx...

opening files in MSO 2000 Publisher created in earlier version
I have a number of publisher files and templates created in earlier versions of Publisher, that I need to use. I am hoping I do not have to re-create all of them. I would prefer not to re-install an earlier version. MSO 2000 Publisher, currently installed will not allow me to open files created in earlier versions. The files do not identify what version they were created in. I originally installed MSO 97 Professional and upgraded to MSO 2000 Professional. I have a stand alone Publisher 98 version but I don't think I ever used it. How can I access these files? zhiva@earthl...

Outlook 2007 and OutlookSecurity.oft
Hi, I'm having a lot of trouble getting the CheckAdminSettings feature of the ORK working with Outlook 2007. I've done this with success many times with Outlook 2000 - 2003, but 2007 seems to completely ignore the form. We have Outlook 2007 clients and Exchange 2003 SP2 server. I've managed to publish the form (had to use Outlook XP to do this) but the OL 2007 clients don't seem to be reading it correctly (I've applied the HKCU CheckAdminSettings reg key). Has anyone managed to get his working with OL2007? I don't want to have to rely on the horrible ClickYes program...

Macro for Auto Fill
Can anyone tell me how to write a macro that will allow me to autofill a column that has mulitple entries: Thanks!!1 Column A Row 1 Sample Row 2 Auto Fill w/ Sample Row 3 Auto Fill w/ Sample Row 4 Data Row 5 Auto Fill w/ Data Row 6 Auto Fill w/ Data You don't need a macro for this. Select Column A and F5>Special>Blanks>OK Type an = sign in active cell then point to cell above. Hit CTRL + ENTER Copy then paste special(in place)>Values>OK>Esc If you prefer a macro....... Sub Fill_Blanks() 'by Dave Peters...

Error with links in Outlook
With certain email subscriptions I get 401 Blocked by Administor when I try to click a link? Any reason for this, it is not all of them, just the about.com. Did your administrator block that domain? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www.onenote-tips.net/ "PaulaD...

Outlook 2003 #176
Sometime when I reply or forward a message, I do not get the icons with the arrow indicating that I replied or forward a message. Has anyone seen this? ...

scheduling
I have a client who is looking for scheduling software that integrates with RMS. they need to be able to schedule classes and trainers, sort of like in a fitness center. Has anyone seen anything like this integrated with RMS thanks, -- Ronald Warsaski World Wide Network Solutions, Inc. Hi Ron, We are finishing an advanced scheduling module in mid - late Novembre. I can send you a 36 page detailed document ifyou wish. Email me if interested. Afshin Alikhani - [afshin@retailrealm.co.uk] CEO - Retail Realm -- URL http://www.retailrealm.co.uk "Ron Warsaski" wrote: > I h...

Sort Macro #4
I've been working on a macro to resort an alphanumeric list to avoid: A1 A10 A2 to rather result in: A1 A2 A10 I have a macro that inserts a leading zero, then I manually sort, then another macro removes the zero. I'd like to combine them into a single subroutine, but I don't know how to sort the currently selected range. Can anyone help? Thank you. Sprinks Selection.Sort ... -- HTH RP (remove nothere from the email address if mailing direct) "Sprinks" <Sprinks@discussions.microsoft.com> wrote in message news:C74100F4-43DF-4617-A8F9-D84D63B1AD2F@micr...