Excel to Outlook Calendar (97)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote