outlook calendar

Help needed, My team and I use a shared excel workbook for scheduling crews and also for overtime work. We currently use a sheet that sorts by overtime hours for calling in employees with the highest amount of overtime hours. I have a sheet that is used enter the employees overtime hours from...

Hello guys, I am trying to modify a code that I found in order to export my calendar appointments in Excel. I need to export "Subject", "StartDate", "EndDate" and "Category". The main issue is that I want on a specific period of time by an Input Box, first to enter the start date and then the...

I'm trying to create a Macro to create Outlook appointments based on words in Column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. I tried <code style="margin: 0px; padding...

Hello, I am currently setting up a spreadsheet for my office in which we can enter appointments and use a macro to send them to specific calendars in microsoft exchange by selecting their name. I currently have this working and sending to calendars that I have made myself but I am stuck with...

It it possible to execute (run) this part of my macro in the background, so the Outlook Appointment window doesn't show? When I delete the " olAppt.Display ", it doesnt add the Selection to the body of the appointment anymore. Set olAppt = Outlook.Application.CreateItem(olAppointmentItem)...

Hello I have the following vba code which creates an appointment in Outlook: I would like the code to enter the appointment in a specific calendar. Calendar is called "Calendar from iCloud" Very much appreciated Sub Appointments() Const olAppointmentItem As Long = 1 Dim OLApp As...

Dear, I am using the code below to create events on my own calendar but I need to the events be create and sent my my secondary email. Can you help me to change the code so my secondary email and calendar are used when creating the event? Sub SendEvent() Dim myoutlook As Object '...

Good Morning All, I'm trying to make a macro that links an excel list of meetings with an outlook calendar. I have created a macro so far that is able to create the entries and check to see if the entry exists by a specific date (which doesn't allow for any flexibility). I now need to make it...

I would like to know if there is any way to automate outlook to create new meeting request and send it automatically like on a certain day every week for a long period of time. The key is for it to be sent only on that certain day and that is why it is different than the multiple occurrence...

Hi, I have looked online to try and get this figured out, but I tend to just get more confused. I have found a code to pull outlook calendar information from outlook to excel. I am trying to determine how to pull from Shared Calendars. This code looks as if they calendar has a number (9), but I...

Have spent a considerable amount of time trying to get my appointment information, from Excel, to post into a non-default Calendar (folder). I have also tried to research this issue a lot, but no workable solution. I used some code to get the folder ID, which works great, and i can get the...

Hi Masters, This is the first time I will post this particular forum "General Excel Discussion & Other Questions". I have created a vba code in excel to send an appointment/meeting in Outlook. I have a leave form request that I want to automate. For monitoring purposes in my calendar for...

I Know how to make an outlook appointment: Sub MakeAppt() Dim olApp As Outlook.Application Dim olApt As AppointmentItem Set olApp = New Outlook.Application Set olApt = olApp.CreateItem(olAppointmentItem) With olApt .RequiredAttendees = Range("B2")...

I have some VBA written in an Excel Workbook that controls some functionality inside of Outlook (ie writes messages). What I need to do is create a macro entirely in Outlook that will turn a message into a calendar appointment. The calendar appointment will always be for 9:30am, BUT the date of...

Using Outlook and Excel 2003 If I export my Outlook Calendar of meetings to Excel, will my meetings still appear in Outlook after the export? I cannot find any documentation if I will lose my meetings in Outlook. Thank you Jeff

Hi, From Excel 2003 to Outlook 2003 Calendar: I have a series of dates and subjects that I want to put in an array and add as an appointment - not a task. I can do this with a single row of data, but not the array. And the array is populated successfully until I add " Const olAppointmentItem =...