Outlook 2013 Appointment through Visual Basic Excell; I want to have an appointment that my calendar says busy and others say free

I'm creating an excel document with a number of different required settings to make the process of logging vacations and business trips in my companies division easier than the current system.

Currently I'm stuck on one small part of the assignment and would like some advice. I am creating an email appointment through outlook that will send out a message to the necessary associates to make certain they know but don't have their calendars busy. This task is easy enough, I set the email message to "free" meaning their calendars are not cluttered yet they get informed. Unfortunately I can't seem to find a way to set the requesters calendar to "busy" in the same appointment while the other recipients are free.

I have a round-about solution which is to send two different emails, one busy the other free. The issue is that this method is cluttered and creates to much hassle for the end user when two emails pop up at once. Optionally I could send it without first displaying the information, but then if they mess up the dates it is created without them looking first. If there is a simpler solution to this issue I would be great full.

If you can aid in just the Outlook portion then I'll be able to find the solution through VBA, but if you have both that would be kind of you to share.

Recent Questions...