outlook appointment

  1. S

    VBA Excel Setting Outlook Appointments From Spreadsheet Data

    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...
  2. D

    macro not always working? writing outlook calendar appointment

    When Outlook is open: both appointments of MB are created. (=good) When Outlook is closed: one or no appointments are created. (=not good) And then, even if Outlook is open, is creates no apoinments anymore. ( MsgBox says it did..) Macro creates Outlook appoinmentments for MB if date in column...
  3. D

    Execute in background

    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)...
  4. S

    VBA Macro to Check for Calendar Items in Outlook and Update if Details Changed

    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...
  5. F

    Adding an attachment to an Outlook calendar invite via Macro

    Hi, I have a macro that is run out of Excel and takes data held in each row and creates an MS Outlook calendar invite from it. However, I cannot figure out how to add an attachment to the body of the Outlook invite via this macro. I have tried recording the addition of an attachment displayed...
  6. R

    Having trouble posting Appointments to (non default) Outlook Calendar using VBA

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top