How Can I create an Outlook Macro to import calendar?

  • Thread starter Thread starter Nrotta
  • Start date Start date
N

Nrotta

Hello Everybody

I wonder if someone could help me.
I would like to create an Outlook Macro to import calendar froma excel file,
instead of using the tradicional Import/export wizard.

Thanks in Advance
 
If you want to work with Excel, add a reference to it via Tools/References.
Use the object browser (f2) to get familar with both models, Outlook and
Excel.

In order to open a spreadsheet, use the Workbooks.Open function. Select
Workbooks in the left pane of the object browser, and the function in the
right pane, then press f1 for more help.

You can use the Range object to loop trough rows and/or columns in the
spreadsheet. The content can be read via Range.Value.

In Outlook create a new appointment by using the CreateItem function.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sat, 6 Feb 2010 11:19:02 -0800 schrieb Nrotta:
 
Back
Top