Automatic Outlook Appointment from Excel Help 2

I am new to this am needing help with it.
I have a spreadsheet that I am using columns A-I. Row 1 is my headers. Row 2 starts my data entry. A the moment I am stopping at row 350 because I have graphs starting there.

Please can someone help me adjust this code to fit what I am trying to do?

1. In column C, I have a custom format setup that I am using. My format is, ("BUMCO-"000000), but all I am getting on appointment is the numbers instead of BUMCO-123456 as it shows on my spreadsheet.

2. I ran this macro and it worked, but when I rerun it duplicates the prior appointments and adds all of the new one. I need to know how to make sure it doesn't duplicate prior appointments.

3. When I run this macro, lets say rows 150-350 doesn't have any data yet. How do I make this macro not add an appointment if there is nothing on the row? Instead of it giving me 200 blank appointments on December 30, 1899


Below is what I am using, it came from the assistance of event21:

Please Login or Register  to view this content.