Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel to Outlook Calendar (97)

    Scenario:

    I have a monthly schedule of jobs that I need to run in my line of work. I don't know the job run dates until a couple of days before the start of the new month and these dates are always one or two days either side of that for the previous month, i.e. job ABC isn't always run on the 3rd of the month, it may be 2nd the next month and 4th the month after.

    At present I am taking these dates as they arrive and manually inputting them onto an Excel workbook that I then print off and stick to my wall, telling me what need running when. Whenever/if I can be bothered, I transfer this info manually into the Calendar on Outlook so that I get a 'popup' the morning a particular job is to be run.

    In my mind, I'm sure there is a way for these dates to be transferred to Calendar automatically (click-of-a-button would suffice) from Excel. Despite extensive searching through VB/VBA help guides, I haven't seen anything that jumps out at me.

    Please don't think I'm just looking for a Guru to sort it all out for me, right down to producing line after line of code, but if anyone could give me some direction in this I'd be very happy. I'm not too skilled in the ways of Outlook although my Excel is coming on well.

    Tks.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to Outlook Calendar (97)

    not so click of the button - but easier than manually creating is file > import > from file.

    export one appt to excel so you get an idea what fields do what.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to Outlook Calendar (97)

    OK - here's an idea.
    Outlook allows you to Import stuff from other files - MS Excel is one file type that is built in to Outlook.
    So, in Outlook, go to File | Import and Export and follow the Wizard. Options required are to Import from a File and File type is Microsoft Excel.
    This should suck in all jobs - you may want to import these as Tasks rather than Appointments.
    The key thing is to get the Excel columns matched to the Outlook type (whether Appointment or Task)
    Probably the easiest way to do this is to perform the reverse operation first. For example, say you decide to use Tasks. Create a task complete with reminder and a Due Date, then use File| Import and Export to export the folder contents to an MS Excel file. This will create all the necessary columns in the Excel file. You can then delete all the rubbish and keep this as a template for imputting your new data - including the all important reminder/date to be implemented.
    HTH
    Silverback

  4. #4
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to Outlook Calendar (97)

    Thanks for the pointers folks. That's given me something to chew over.

Posting Permissions

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