I have a .csv file that gets generated each day that i want to import into a
shared calendar on the network (not my default calendar). How do i write a
macro that will import the calendar to the shared calendar and map the
fields? It would also need to replace existing appoinments instead of adding
duplicates. The .csv will always have the same name, location and layout. Any
ideas would be appreciated.

The samples at http://www.outlookcode.com/article.aspx?ID=23 should get you started. As for replacing existing appointments, you'll have to decide what criteria define a duplicate and use those in a MAPIFolder.Items.Find search.

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


"Dave L" wrote in message ...
I have a .csv file that gets generated each day that i want to import into a
shared calendar on the network (not my default calendar). How do i write a
macro that will import the calendar to the shared calendar and map the
fields? It would also need to replace existing appoinments instead of adding
duplicates. The .csv will always have the same name, location and layout. Any
ideas would be appreciated.

Hi Dave,

I have the exact requirement as you, importing from a CSV file, did you had
any sucess automating the same? I have some knowledge in scripting, pls share
if u made the code, mail me to coolsanthosh82 AT hotmail.com

thanks

"Dave L" wrote:

I have a .csv file that gets generated each day that i want to import into a
shared calendar on the network (not my default calendar). How do i write a
macro that will import the calendar to the shared calendar and map the
fields? It would also need to replace existing appoinments instead of adding
duplicates. The .csv will always have the same name, location and layout. Any
ideas would be appreciated.

you may also leave the code in this forum, so that others can benfit from you
work

"Dave L" wrote:

I have a .csv file that gets generated each day that i want to import into a
shared calendar on the network (not my default calendar). How do i write a
macro that will import the calendar to the shared calendar and map the
fields? It would also need to replace existing appoinments instead of adding
duplicates. The .csv will always have the same name, location and layout. Any
ideas would be appreciated.

I, too, scoured my resources for an easy way to do this. My solution was a
little different. I used a keyboard/mouse automatino tool. In EXCEL there
is a recorder that will record our actions then let us edit and replay them.
This tool doesn't appear to have a recorder but I really only needed to
execute a few commands (File/import/from external program .. etc)

The tool I used to AUTOIT and doctored up their NOTEPAD example. It even
allows me to compilet he script into a small executable so I can create the
calendar entry anywhere and could edit the macro to start outlook/ open the
calendar and complete the import of one or more entries.

It's just a thot !!


"Santhosh" wrote:

you may also leave the code in this forum, so that others can benfit from you
work

"Dave L" wrote:

I have a .csv file that gets generated each day that i want to import into a
shared calendar on the network (not my default calendar). How do i write a
macro that will import the calendar to the shared calendar and map the
fields? It would also need to replace existing appoinments instead of adding
duplicates. The .csv will always have the same name, location and layout. Any
ideas would be appreciated.