Hello Bmasella,
Here is the macro to create the Outlook "All Day" calendar item. I used the cell references you supplied. You can create a loop to pull the dates and supply them to the macro, The macro will then create the item, and save it in Outlook. Attach the looping macro to a Forms Toolbar button.
Create "All Day" Appointment Item in Outlook
Adding the Macro to your Workbook
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S
Sincerely,
Leith Ross
Bookmarks