Pull Data From Non-Default Calendar

Status
Not open for further replies.
E

eckert1961

Hello,

I am running Outlook 2003 and I have a macro that pulls data from the

default calendar. I created a new calendar named "Instructor Schedule" which

is a subfolder under Calendar. I would like to change the code so that the

data is pulled from the new calendar. Currently I am using the following code.

Set colCal = objNS.GetDefaultFolder(olFolderCalendar).Items

What change would I need to implement to get my desired results? Thanks.

Regards,

Chris

Regards,

Chris
 
K

Ken Slovak - [MVP - Outlook]

Set colCal =

objNS.GetDefaultFolder(olFolderCalendar).Folders.Item("Instructor

Schedule").Items

"eckert1961" <eckert1961> wrote in message

news:72AFD85A-E977-4DBF-A871-64065373B0F4@microsoft.com...
> Hello,

> I am running Outlook 2003 and I have a macro that pulls data from the
> default calendar. I created a new calendar named "Instructor Schedule"
> which
> is a subfolder under Calendar. I would like to change the code so that the
> data is pulled from the new calendar. Currently I am using the following
> code.

> Set colCal = objNS.GetDefaultFolder(olFolderCalendar).Items

> What change would I need to implement to get my desired results? Thanks.

> Regards,
> Chris
> > Regards,
> Chris
 
E

eckert1961

Thanks for the quick response Ken. That worked perfectly.

Regards,

Chris
wrote:


> Set colCal =
> objNS.GetDefaultFolder(olFolderCalendar).Folders.Item("Instructor
> Schedule").Items

> >

>

> "eckert1961" <eckert1961> wrote in message
> news:72AFD85A-E977-4DBF-A871-64065373B0F4@microsoft.com...
> > Hello,
> > I am running Outlook 2003 and I have a macro that pulls data from the
> > default calendar. I created a new calendar named "Instructor Schedule"
> > which
> > is a subfolder under Calendar. I would like to change the code so that the
> > data is pulled from the new calendar. Currently I am using the following
> > code.
> > Set colCal = objNS.GetDefaultFolder(olFolderCalendar).Items
> > What change would I need to implement to get my desired results? Thanks.
> > Regards,
> > Chris
> > > > Regards,
> > Chris


> .
>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
C Pull Outlook shared calendars items from Excel Outlook VBA and Custom Forms 4
J Pull an email address from body and replace reply-to address Outlook VBA and Custom Forms 4
C Subject Line - Pull Down (Customizeable) Menu Outlook Wishlist 1
M rule to change subject, pull email addresses from body, and forward with templ Using Outlook 14
D Redemption? Need rapid pull of Outlook Contacts, email + notes for VBA Using Outlook 1
A Pull mail without marking and processing, only by selecting it Using Outlook 1
J multiple email accounts, but only want to pull from two Using Outlook 1
Commodore Back/Forward toolbar buttons with pull-down history? Using Outlook 5
K Custom Content Control or field to pull specific Outlook Address Book information into Word doc? Using Outlook 1
L Getting a 'Not Responding' message in Calendar only? Won't pull up? Very frustrating. Using Outlook 1
K Need to pull Outlook '07 contact information into Word document Using Outlook 1
P How do I set up MS Outlook 2003 to automatically pull in any e-mails that are sent to me? Using Outlook 1
F Outlook 2010 will not pull in my email from my provider &amp; the font in the body of the message area is so small it can't be read unless I use a #72 Using Outlook 5
L Why does it take so long for outlook to pull up when it is open and on__my taskbar? Using Outlook 0
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 3
T How can Exchange be configured to sync/push one-way so that the server data can't be affected Exchange Server Administration 0
C Can't create Outlook data file Outlook Wishlist 0
T Extract Data From Outlook Tasks Using Outlook 0
F outlook.com Exchane Server corrupts data Since September 2019 Using Outlook.com accounts in Outlook 6
T Extract Data From Outlook Tasks Using Outlook 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
R "Can't store Outlook data files under the AppData folder. Please choose another folder." Using Outlook 6
C How to export Outlook data to csv? Using Outlook 0
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
S newly added shared mailboxes downloading 500GB data a day Exchange Server Administration 1
M Using field names to capture a data element Using Outlook 0
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
M Outlook 2016 Requesting data from server Using Outlook 0
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
Sofia Manni Some of my favorite data in outlook. Using Outlook 2
A Outlook 2016 Will Not Show Any Data In the People Pane Using Outlook 14
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
P Microsoft Outlook is requesting data from the server Using Outlook 2
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
M adding corresponding contact form data on a mass scale Using Outlook 5
J Calendar data can be viewed on Outlook.com, but no longer syncs to Outlook 2013 Using Outlook.com accounts in Outlook 3
M Retrieve data from GAL and put it in Clipboard Using Outlook 1
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
G Using Data From Combo Box in Appointment Body Outlook VBA and Custom Forms 6
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Diane Poremsky Set Another Data File as Default When Using an Exchange Account New Slipstick.com Articles 0
Diane Poremsky How to Compact the Data File When you Close Outlook New Slipstick.com Articles 0
T Uploading Outlook 2016 Contacts to Exchange Server Drops "Company" field data in 30% of records Exchange Server Administration 4
Diane Poremsky Rename Email Accounts and Data Files in the Folder List New Slipstick.com Articles 0
J create .pst data file for new gmail account Using Outlook.com accounts in Outlook 1
M Dilemma: to add to existing data file or not to? Using Outlook 16
Similar threads


















































Top