Way to create Outlook Calendar Events from Spreadsheet

Posted on 2011-10-31
Last Modified: 2012-05-12

If I have a spreadsheet that contains all of the relevant data (Subject, Location, Start and End Times, Notes), is there a way to automatically create Outlook Calendar Events?
Question by:BBlu
    LVL 6

    Expert Comment


    yes, there is a way.
    Check out the following post about creating outlook calendar appointment.

    Author Comment

    I'll try that and try to understand it.  It looks like it's just for one record.  Would you know how to revise it so that it loops through a spreadsheet?
    LVL 31

    Expert Comment

    by:Rob Henson
    You can setup a CSV file with the relevant details to Import into Outlook.

    For example the attached does Bank Holidays.

    Rob H Bank-Holidays.csv

    Author Comment


    I was actually hoping to do it via VBA.  I think I would know how to do it via an import.  I was just hoping to learn a new trick.
    LVL 31

    Accepted Solution

    You could amend the code on the suggested link to pull data from columns in a worksheet.

    You would then need a For/Next or Do/Loop statement amending the row reference for the required data.


    For R = 1 to 10

    Copy data from Row R, Column A
    Copy data from Row R, Column B
    Copy data from Row R, Column C...

    Next R

    This would loop thorugh rows 1 to 10 copying data.

    The range of values for R could be dynamic if so required

    Rob H

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now