[Last Call] Learn how to a build a cloud-first strategyRegister Now


Adding a name to 5 calendar dates in Outlook 2003

Posted on 2007-07-31
Medium Priority
Last Modified: 2010-04-08
In Outlook 2003, I have a schedule of classes for the entire week in my calendar. So for instance I have Word 1 on Monday, Word 2 on Tues, etc. After all of these are in the calendar, if someone emails and says I want to sign up for all 5 Word classes next week, is there any way to add there name to every class that week without have to cut and paste 5 times one for each day or can I add them to all 5 days in one fell swoop?

Question by:contrain
  • 4
  • 2
LVL 76

Expert Comment

by:David Lee
ID: 19621636
Hi, contrain.

Yes, it's possible using a bit of scripting.  Is that an option?

Author Comment

ID: 19621791
Possibly, what would I have to do?
LVL 76

Expert Comment

by:David Lee
ID: 19629004
You'd select the classes you want to add the person to, then run a macro.  The macro would add the person to all selected classes.
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.


Author Comment

ID: 19642160
How would I create this macro in Outlook?
LVL 76

Accepted Solution

David Lee earned 2000 total points
ID: 19642691
Here's the macro.  Follow these instructions to use it.

1.  Start Outlook
2.  Click Tools->Macro->Visual Basic Editor
3.  If not already expanded, expand Modules and click on Module1
4.  Copy the code below and paste it into the right-hand pane of the VB Editor
5.  Edit the code as needed.  I placed a comment before each line that needs to be edited
6.  Click the diskette icon on the toolbar to save the changes
7.  Close the VB Editor
8.  Click Tools->Macro->Security
9.  Change the Security Level setting to Medium
10.  Select one or more appointments on any calendar.
11.  Run the macro.  It will display a dialog-box prompting you to enter a name or email address.  If you don't enter anything or if you click cancel, then the macro does nothing.  

Sub AddRecipientToAppointment()
    Dim olkAppointment As Outlook.AppointmentItem, _
        olkRecipient As Outlook.Recipient, _
        strName As String
    strName = InputBox("Enter the name or email address of the person to add to the appointment.", "Add Recipient to Appointment")
    If strName <> "" Then
        For Each olkAppointment In Application.ActiveExplorer.Selection
            With olkAppointment
                Set olkRecipient = .Recipients.Add(strName)
                olkRecipient.Type = olTo
            End With
    End If
    Set olkRecipient = Nothing
    Set olkAppointment = Nothing
End Sub
LVL 76

Expert Comment

by:David Lee
ID: 20518674
Is there anything else I can do to help with this question?

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 trialware OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their Exchange server is no longer available or other critical issues with Exchange server or impo…
This article will help to fix the below errors for MS Exchange Server 2016 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question