How to move or import appointments from an Outlook calendar into a Group Calendar.
The following code works in Outlook 2000 and up. It saves the attachments from selected messages but does not delete the attachments from the message(s). This VBA code is based on the code sample at our Outlook-Tips site: Save and Delete Attachments. Use it if you want to save the attachment, add a link to
Use a macro to quickly add the sender of an email to a Contact Group.
Although Outlook VBA doesn't include a paste from clipboard function directly, you can use the MSForms dataobject to transfer the clipboard contents to a string which is then called from VBA.
A VBA code sample that creates an appointment from an email message and adds it to a shared calendar or a calendar in another data file.
Use an ItemSend macro in Outlook to replace display names on messages with the email address as the message is sent.
I often need to copy a Contact's details to share with others and to put into appointments.
Victor Beekman wanted to share another macro with our visitors. This is similar to our macros that search for all messages from a contact or sender but instead of doing an "in-place" search, it opens a new window with the results.
Use VBA to watch for new appointments added to the calendar and copy them to a second calendar. This is useful if you are syncing with a second calendar and only want some items synced. New: watch for updates to the original appointment and change the copied appointment.
Use RegEx to copy text from an email message and insert it into an Excel workbook.
Create tasks from email as they arrive using a simple script and Rules Wizard. With a slight variation, you can create a task from the message you are reading in the reading pane. Complete instructions and ready-to-use code samples included.
Use an Excel macro to create appointments in subcalendars in Outlook. To use, type the appointment data, including the calendar name, into the spreadsheet then run the macro. The macro creates appointments in the correct calendar folder.
Use VBA to select multiple calendars in overlay mode. Can deselect iCloud calendars using this code. Code Sample included.
I have a macro that defers sending messages that are composed during a specific time period, such as during the overnight hours. After several users asked how to send responses or forward messages if the new messages arrived during the overnight hours, it's time to add macros for incoming messages as well. I would like
An Outlook user wanted to know how to create a task from an email message but only include the actionable part of the message in the task. Easy: drag the selection to the Task or Calendar folder or use a macro.