Copy Events to Second Calendar or Sync Only "Busy" Events

Not open for further replies.


Outlook version
Email Account
First, my thanks again for solving one of my long-running problems on my last post. The other issue that I can't solve is this: My calendar is loaded with work and family events, as well as sports team schedule downloads, holidays, etc. (I mark the important stuff as "busy" and everything else as "free.") I sync my i-phone with that calendar. My wife doesn't need all that stuff so I built a second calendar to sync with her i-phone. She only needs events that are "busy." So I copy/paste events one at a time to the second calendar. That is very tedious! Is there an easier way to do this? (Copy/paste for both events and contacts seems very tempermental. You must right-click the item, then click the "edit" tab then "copy" and then you must carefully click the place you wish to paste before you can actually paste... and sometimes "copy" or "paste" is greyed out and not an option!!! Am I doing it wrong?) Thank you again for all of your help!!!
Should be able to just drag the busy items from your calendar to her calendar folder name.... but the only other way is with a VBA - it can detect new items and copy them to her calendar.

This is a manual macro - Copy meeting details to an Outlook appointment - Slipstick Systems - if you want to copy the appointment, you run the macro.

This macro can copy the events automatically as you add them to your calendar - Save appointments to a non-default Outlook calendar folder - Slipstick Systems You'll need to change Item.Move to Item.copy and wrap it in an if-then statement -

If item.BusyStatus = olBusy Then

' copy

end if
Thanks for the reply. The drag suggestion will MOVE the event from one calender to another. I need to copy / paste the event, which still requires the tedious task I described (I know there is a ctrl-click-drag maneuver, but more than once the event "fell" into the wrong place while dragging and totally mixed us up!). As for the macro, the instructions in the link were almost literally a different language to me. I need a step-by-step for how to create and how to utilize such a feature (I don't even know what VBA means!) Thanks again!!!
Thanks again!! I got all the way to the last 2 steps in the macro instruction, but wasn't sure how to "place mouse in application_startup macro" When I hit F5 I got a "compile error - user dfined type not defined" and the text "Function GetFolderPath(ByVal FolderPath As String) As Outlook.Folder" was highlighted. (BTW I am using Outlook 2003.) Incidentaly, my issue with the CTL/Drag is that while dragging, the slightest flinch with the mouse will drop an event(s) in the wrong place - sometimes in the calendar it came from! I have been able to group a "busy" list view to copy / paste several events. Thanks for all of your recent help!
It should work in 2003 - I'll test it to be sure. I'm not sure what caused that error either.

Have you tried click lock? It locks the selection until you click to release. I personally don't care for it, but I know several people who prefer it, in part because it does prevent mistakes when dragging. I guess its all in what you get used to. It's enabled in Control panel > Mouse. Outlook Tips | Tip 951: Stop Accidentally Dragging Outlook Folders

The application Start macros run when outlook starts - so it test it without restarting outlook, you need to click anywhere within the application startup macro then click run. You can click anywhere between Sub / End sub. I usually hit the first line.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
C Copy from one Profile to another Using Outlook 0
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
D Copy Appointment Body to Task Body Outlook VBA and Custom Forms 0
M copy field value to custom field Outlook VBA and Custom Forms 0
O In Agenda-view - How to copy an existing item months ahead or back? Using Outlook 0
C Move or copy from field to field Outlook VBA and Custom Forms 0
Z Copy specific email body text Outlook VBA and Custom Forms 0
B Need to Copy an email to a subfolder Outlook VBA and Custom Forms 2
O Outlook 365 - How to create / copy a new contact from an existing one? Using Outlook 5
S Copy Tasks/Reminders from Shared Mailbox to Personal Tasks/Reminders Outlook VBA and Custom Forms 0
A Cannot copy this folder because it may contain private items Using Outlook 0
C Copy Move item won't work Outlook VBA and Custom Forms 2
Z VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
Commodore Move turns into "copy" Using Outlook 3
C Copy Outlook contact field value to another field Outlook VBA and Custom Forms 1
J Copy to calendar function no longer working in outlook 365 Using Outlook 5
F Copy and replace not update contact in another pst Using Outlook 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
Commodore Folders always closed in move/copy items dialog box Using Outlook 3
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
geofferyh Outlook 2010 How to Copy Outlook Attachment to a Specific Folder? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
R Copy Outlook Public Folders to a File Server Shared Folder Using Outlook 0
K Outlook Rules: Move a Copy Using Outlook 4
oliv- HOW TO COPY /USE FOLDERS ICONS Outlook VBA and Custom Forms 2
E Copy e-mail body from outlook and insert into excel Outlook VBA and Custom Forms 3
B Copy/Move Exchange inbox to Pop inbox Using Outlook 4
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
O Copy mails from many subfolders to 1 foldr Using Outlook 2
K ind specific Subject line from outlook and copy the content of the email body to exce Outlook VBA and Custom Forms 0
K How to find specific header and copy the mail body Using Outlook 0
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
Carrie Dickey Outlook 2016 created two calendars titled Calendar1 - appear to be a copy Using Outlook 2
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
R Macro to copy email to excel - Runtime Error 91 Object Variable Not Set Outlook VBA and Custom Forms 11
H Macro to Copy Specific content from Mail Body and Paste to Excel Outlook VBA and Custom Forms 4
M How to keep reccurence during copy tasks to calendar? Using Outlook 1
Diane Poremsky Copy New Appointments to Another Calendar using VBA Using Outlook 0
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook Using Outlook 0
C Copy Task to Non-Microsoft PIM "Rainlendar" Using Outlook 0
G VBA Copy draft email to a new email - attachments not copided Using Outlook 7
C Copy email to excel runtime error 5020 Using Outlook 5
I Copy email from folder to folder - FAILS Using Outlook 5
M Copy new appointments created in multiple shared calendars to another exchange calendar Outlook VBA and Custom Forms 1
Q Why can't I copy image with embedded hyperlink from email to Word Using Outlook 0
I How to make a copy of a task Using Outlook 8

Similar threads