A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

linking Outlook 2007 calendar to Access 2007



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 09:16 AM posted to microsoft.public.outlook.general
Kathryn
external usenet poster
 
Posts: 108
Default 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  
Old June 3rd, 2010, 10:23 AM posted to microsoft.public.outlook.general
Roady [MVP]
external usenet poster
 
Posts: 23,553
Default 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  
Old June 3rd, 2010, 12:29 PM posted to microsoft.public.outlook.general
Kathryn
external usenet poster
 
Posts: 108
Default 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  
Old June 3rd, 2010, 04:07 PM posted to microsoft.public.outlook.general
Roady [MVP]
external usenet poster
 
Posts: 23,553
Default 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  
Old June 4th, 2010, 08:30 AM posted to microsoft.public.outlook.general
Kathryn
external usenet poster
 
Posts: 108
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:29 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.