Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / December 2006

Tip: Looking for answers? Try searching our database.

Weeky job macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Justyn Case - 22 Nov 2006 11:54 GMT
A colleague has asked for help that is beyond my skill to give.  I'm not
even sure that what she wants is possible.  Here's the setup.

We run Outlook 2003 on Windows XP SP2 with Office 2000.  She has some
templates stored in her file system that she sends weekly, say Friday.
Sometimes she forgets or is too busy, so she wants to automate the process.

The ideal would be a macro that ran, say, every Friday at 2pm without
human intervention that automatically sent the templates (which are
pre-addressed and do not change their wording).

Second best would be a macro that sent the templates that I could attach
to a toolbar button.  But avoiding relying on her being free to do the job
would be a lot better.

Any help will be gratefully received.

Justyn Case.
Sue Mosher [MVP-Outlook] - 30 Nov 2006 16:18 GMT
If these messages are to internal recipients, you could publish the templates as custom forms and use the method described at http://www.outlookcode.com/d/forms/skedrpt.htm.

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

>A colleague has asked for help that is beyond my skill to give.  I'm not
> even sure that what she wants is possible.  Here's the setup.
[quoted text clipped - 14 lines]
>
> Justyn Case.
Justyn Case - 05 Dec 2006 09:50 GMT
Many thanks, Sue.  Just what I wanted.

Justyn.

> If these messages are to internal recipients, you could publish the templates as custom forms and use the method described at http://www.outlookcode.com/d/forms/skedrpt.htm.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.