If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking Outlook 2007 calendar to Access 2007
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! |
#2
|
|||
|
|||
linking Outlook 2007 calendar to Access 2007
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! |
#3
|
|||
|
|||
linking Outlook 2007 calendar to Access 2007
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! |
#4
|
|||
|
|||
linking Outlook 2007 calendar to Access 2007
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! |
#5
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|