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