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:
Any help or insight much appreciated!
- 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.