June 4th, 2010, 08:30 AM
posted to microsoft.public.outlook.general
|
|
|
linking Outlook 2007 calendar to Access 2007
Many thanks - will have a go!
"Roady [MVP]" wrote:
The linking can be done is some easy steps from within Access as it is a
wizard.
Setting up VBA can be as complicated as you want it; it all depends on what
exactly you want to do.
A good place to start is;
http://www.outlookcode.com
Or ask in the developer newsgroups "down the hall".
--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more
http://www.msoutlook.info/
Real World Questions, Real World Answers
-----
"Kathryn" wrote in message
...
Thanks Robert
I think the "from Access to Outlook" would be the best way round as the
person taking the bookings will be working straight into Access... my
thought
was to save the second step of updating the Outlook calendar.
Is the setting up you suggest complicated? I have been working in Access
for
a few months but haven't really done any VBA.
Thanks
"Roady [MVP]" wrote:
If you want to setup a link between Access and Outlook, importing is not
the
way since that won't be a link.
To create a link, you'll have to set it up from within Access;
Select the External Data tab- button More in the Import section-
Outlook
Folder
To have it work from your existing Access database or if you want to
apply
custom action, then you'll have to use VBA.
--
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com/
Outlook FAQ, HowTo, Downloads, Add-Ins and more
http://www.msoutlook.info/
Real World Questions, Real World Answers
-----
"Kathryn" wrote in message
...
I am trying to link bookings in our Acess 2007 database with an Outlook
2007
calendar and started following the Outlook: File Export/ Import
Import
from another program route ... but my choice for Access only comes up
as
Access 1997-2003 which, of course, doesn't find my database!
Does anyone have any ideas on how to resolve this?
Many thanks!
|