Some things are too good not to share
This is one of them
How about if I show you how to take rows in Excel and make them appointments in Outlook?
Well then, you must read on
Managing your calendar is a critical success factor at almost any company
If I can automate anything I will spend the time to do it
This utility has served me well over the years
Figure 1: Excel to Outlook
It is a simple question of taking cells in Excel and making them properties in an Outlook appointment
Just write a loop in VBA and go through all the rows in Excel and writes appointments in Excel
There are endless possibilities here
Is it possible to have this code run for the current row only? For my purpose, I'd like to enter in my data and then click a button on the toolbar to add the current row (only) to outlook.
This is much better than the many examples I found so far, over a week of searching!
Thank you :-)
Can you please post example workbook?
is it possible to create same for LYNC online meeting
This has proved really useful to a non-VBA competent novice like me.
I'm trying to run the macro on existing data and for it only to pick up 'new' rows that I've added since last running the macro. What can I add to the code to check for duplicates to prevent further diary invitations going out?