Re: [Nolug] need windows macro help

From: Jonathan Schwehm <jonathan_at_figstreet.com>
Date: Fri, 11 Feb 2005 08:44:16 -0600
Message-ID: <420CC4C0.4030002@figstreet.com>

You can reference the Outlook library in a stand-alone VB executable.
Then you'd have to schedule it as Kevin mentioned.

If Outlook will be running, a VB macro with a Timer may work. It can be
setup to start when Outlook starts, but it all depends on your
requirements and what the user wants. Also, what end result do you want
to accomplish? I can probably put together a VB macro that runs in
Outlook to export calendar fields. It should shed some light on how to
do this in VB.

Jonathan

Joey Kelly wrote:
>>Otherwise, it looks like you'll need to write a VB program using the
>>Outlook.{Application,Namespace,MAPIFolder,ContactItem,...} COM objects,
>>then probably use Task Scheduler to actually run the program.
>>
>>Hope this helps,
>>Kevin
>
>
> Is it possible to have a script run in the background? Or is everything
> absolutely tied to the GUI? I can already point-and-click and export to Excel
> format, though making it cleaner or shorter (perhaps 1 click to do
> everything, for instance) might be helpful.
>
> I'd really like to have it happen hourly without the user having to do
> anything. One of the users in question will probably balk at having to
> manually export his data (and he's a high-level manager, so I'm not going to
> be able to make him do it).
>
___________________
Nolug mailing list
nolug@nolug.org
Received on 02/11/05

This archive was generated by hypermail 2.2.0 : 12/19/08 EST