Automatic Outlook Appointment from Excel Help

I don't know what you mean by this:

I am wanting to automatically make an All Day Appointment that reminds me for each row using column A as my Subject, column B as my Location, and column E as the Date.

Hi -

Do a conditional formatting in column E to check if the dates in there is today's date then color the cells.
Not sure if this is what you want.

event

Sorry stnkynts, I typed this in a hurry and I forgot to type what I was thinking. I have amended my post. I and trying to make appointments in Outlook from Excel.

Hi event2, This won't help me with what I am trying to do. I left out information, but have fixed it now.

Hi -

Thanks for addressing the incorrect Title.

try something like;

Please Login or Register  to view this content.

event

Thank you. This seems to have work. I have a few follow up questions.
1. How to tell it to stop on lets say row 350? I have a few charts and graphs that is coming back with errors.
2. It is not taking my custom format from column C. My format is, ("BUMCO-"000000), all I am getting is the numbers.
3. Will this update as I update my spreadsheet, or will I have to click run macro everytime I update my sheet?
4. I ran it once and it worked. I filled in two rows, reran it and it duplicated at the prior ones and added these. So now I need to know how to make sure it doesn't duplicate prior rows.

Hi -

1. change from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

2. Column C is not taking into account in my script as well as the thread requirement.The only mentioned columns are A,B and E
3 & 4. You need to run the macro everytime you made an update on the excel and you want to update the outlook as well. you need to add script to check if the appointment is already exists.(Google it, you now have the base script.)

event