How Can I create an Outlook Macro to import calendar?

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
 
M

Michael Bauer [MVP - Outlook]

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook calendar export macro 1
how do I create an import spec in Outlook to import Access calend. 1
Macro to Import Excel Dates to Outlook Calendar 1
Importing Schedule into Outlook from Excel 1
Macro to export Outlook contacts 1
Outlook automation 2
How do you write a macro to automatically import and map a calenda 4
How to Create a Macro to Import External Data 0

Top