+ Reply to Thread
Results 1 to 2 of 2

Send CSV events to Outlook non-default calendar folders via excel?

  1. #1
    Forum Contributor
    Join Date
    10-01-2008
    Location
    Eureka, CA
    Posts
    161

    Send CSV events to Outlook non-default calendar folders via excel?

    Hi, I've got a spreadsheet that my company uses to create multiple staff schedules. Each time a schedule is created, a csv file is created that i can import into outlook calendar. Currently we make about 35 individual schedules each month, so importing each one into outlook would be a bit of a burden. I was wondering if this could be done automatically with vba directly from excel at the same time that the csv file is created. I'm pretty sure that can be done, but there is more.

    The purpose of doing this in the first place is so that all of our supervisors would be able to see all 35 schedules on their company supplied iphones. We have already created an exchange account that we link to each persons phone and outlook so that we can have shared contact lists. So what needs to happen is for the csv file to be imported into the shared exchange account calendars. Is this even possible?

  2. #2
    Forum Contributor
    Join Date
    10-01-2008
    Location
    Eureka, CA
    Posts
    161

    Re: Send CSV events to Outlook non-default calendar folders via excel?

    I have seen on another forum that events can be added to non-default calendars from excel, I wonder if that might be an option instead of importing a csv all at once, possibly a loop to add each scheduled shift one at a time?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Set Up Macro to send reminders to Outlook Calendar
    By slohman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2013, 11:21 PM
  2. send selected range in email with default outlook email signature included
    By mdsickler in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 10:50 PM
  3. Change MS outlook default calendar folder
    By DB4284 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2010, 06:30 AM
  4. Import worksheet data to outlook calendar events
    By jodyatspd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2008, 09:24 AM
  5. Outlook 2003 calendar events into Excel 2003?
    By Kolin Tregaskes in forum Excel General
    Replies: 4
    Last Post: 01-31-2005, 04:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1