Link appointment to Excel range

[Cranky]

Hi

We currently record staff daily duties on an Excel spreadsheet, and we
also have a team Outlook calendar. It's too complicated trying to put
duties on as daily appointments within Outlook as there are several
staff doing up to 9 different jobs.

So what I want to do is for each day set up an appointment called
'rota' every day where the 'body' field contains that day's
information from the spreadsheet, which updates whenever the
spreadsheet is adjusted. I'm assuming it would require named ranges
for each day, if it's possible, but can't see any way forward.

I realise I can copy the area on the spreadsheet and then paste it
into the calendar appointment each day - which is more time consuming
than I'd like, or create a hyperlink to a bookmark within the
spreadsheet, which means opening up Excel, doesn't it?

Any advice at all would be great, and very appreciated.

Thanks

Steve

 

[Roady [MVP]]

No, that's not possible. Why are you actually using Excel for this?
You can put the Calendar of Outlook also in a table form if that helps with
inputting the information into Outlook.
Depending on your version of Office, Access has better integration options
with Outlook which can sync 2 ways.

 

[Crankylemming]

Hi

Thanks for your reply. We use Excel simply because we always have done
and nobody here knows a great deal about Access. We're on Outlook
2003.

When you say about seeing the calendar in table format, do you meran
the daily view?

Thanks

Steve

 

[Roady [MVP]]

No, a table view like All Appointments or By Category. You can find it in
the View menu.

Only one person needs to know something about Access, then he/she can create
a special input form and report.
This is actually quite basic stuff which for the most can be created with
step-by-step wizards in Access. Not a whole lot knowledge is required for
it. Things have been made even easier in the 2007 versions of Access and
Outlook.

I wouldn't use Excel for this and keeping it for nostalgic reasons isn't a
business decision ;-) Perhaps switching to a table view removes the need of
using Access as well so you can do everything in Outlook.