amozza
09-06-2007, 10:44 AM
Hello there,
I'm just getting started with VBA in Office 2007 and can't get my grips with Outlook.
I'm looking for some help creating a macro to export certain fields from calendar items in Outlook 2007 and dump them in an existing Excel 2007 document. Here are the details:
Prompt user for a start and end date (with two input boxes or a simple form I can design)
Cycle through those dates and pull the Subject, Date, Start Time, and End Time for all appointments
Open an existing Excel 2007 document template and add the data to a specific cell range (or cell starting point)
Run another macro I've already created in that Excel document to format the text and save as a new file.Any help or insight much appreciated!
I'm just getting started with VBA in Office 2007 and can't get my grips with Outlook.
I'm looking for some help creating a macro to export certain fields from calendar items in Outlook 2007 and dump them in an existing Excel 2007 document. Here are the details:
Prompt user for a start and end date (with two input boxes or a simple form I can design)
Cycle through those dates and pull the Subject, Date, Start Time, and End Time for all appointments
Open an existing Excel 2007 document template and add the data to a specific cell range (or cell starting point)
Run another macro I've already created in that Excel document to format the text and save as a new file.Any help or insight much appreciated!