automate export agenda for off-line use

Hi,

We do NOT have an Exchange server.
I have a user with a laptop and office 2003. She manages het own agenda in
Outlook 2003.
We have some other users that need to look into her agenda and they still
use outlook 2000.

Manually I can have her export het agenda to a Outlook 2000 PST file on the
server. The other users can then open the PST file.
This has been working for some time but.... I want to automate the export
process via a button and a VBA script.

As Outlook cannot record a macro and it has way to many
options/functions..... :-( where do I begin?
I know about VBA programming but I have no idea how to specify the following
sequence (which the user does manually each day')
In Outlook, File, Import / Export, to file, to PST file.
Select Agenda folder
Select file (for instance S:\Agendas\User1\Agenda.pst)
Set proper option for duplicate items
Export
It's probably just one function with lots of paramaters but which?

Also, how do I make sure it is exported to an Outlook 2000 pst file,
probably by writing to an existing Outlook 2000 pst file right?

Bonno

> where do I begin?

Start with the basics at http://outlookcode.com/article.aspx?id=49 and then start exploring the Outlook object model using the object browser (F2 in VBA) and the many samples available on the Internet.

> I have no idea how to specify the following
> sequence (which the user does manually each day')
> It's probably just one function with lots of paramaters but which?

Forget about automating the built-in export feature. It is not exposed to programmers. Instead, you would need to write your own export macro, such as the example at http://www.outlookcode.com/codedetail.aspx?id=646

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Bonno Bloksma" <tioein@xs4all.nl> wrote in message news:47692abd$0$85794$e4fe514c@news.xs4all.nl...
> Hi,
>
> We do NOT have an Exchange server.
> I have a user with a laptop and office 2003. She manages het own agenda in
> Outlook 2003.
> We have some other users that need to look into her agenda and they still
> use outlook 2000.
>
> Manually I can have her export het agenda to a Outlook 2000 PST file on the
> server. The other users can then open the PST file.
> This has been working for some time but.... I want to automate the export
> process via a button and a VBA script.
>
> As Outlook cannot record a macro and it has way to many
> options/functions..... :-( where do I begin?
> I know about VBA programming but I have no idea how to specify the following
> sequence (which the user does manually each day')
> In Outlook, File, Import / Export, to file, to PST file.
> Select Agenda folder
> Select file (for instance S:\Agendas\User1\Agenda.pst)
> Set proper option for duplicate items
> Export
> It's probably just one function with lots of paramaters but which?
>
> Also, how do I make sure it is exported to an Outlook 2000 pst file,
> probably by writing to an existing Outlook 2000 pst file right?
>
> Bonno
>
>