Connecting Tech Pros Worldwide Forums | Help | Site Map

Opening outlook items from Access form

rwm rwm is offline
Newbie
 
Join Date: Jul 2007
Posts: 3
#1: Jul 3 '07
Hi

Before updating to Access 2007 we could open outlook contact entries by using a hyperllink along the lines of <outlook://contacts etc>
This does not seem to work in 2007 any more.
We have a linked table in the database which is drawing data from the outlook contact file and have related this to the relevant access tabel so we can see all the data from both tables in the access form but I am at a loss as to how to actually open the relvant outlook contact file from the access form.
I'm sure I'm missing something simple but any help would be much appraciated

puppydogbuddy's Avatar
Expert
 
Join Date: May 2007
Location: Florida
Posts: 1,915
#2: Jul 7 '07

re: Opening outlook items from Access form


Quote:

Originally Posted by rwm

Hi

Before updating to Access 2007 we could open outlook contact entries by using a hyperllink along the lines of <outlook://contacts etc>
This does not seem to work in 2007 any more.
We have a linked table in the database which is drawing data from the outlook contact file and have related this to the relevant access tabel so we can see all the data from both tables in the access form but I am at a loss as to how to actually open the relvant outlook contact file from the access form.
I'm sure I'm missing something simple but any help would be much appraciated


try this:

1. create a shortcut for your Outlook Contacts folder on the desktop

2. Right click on an open area of the desktop

3. Select New / Shortcut

4. Enter in the path to your outlook program followed by outlook:contacts. Note the quotes are necessary:

Example
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE outlook:contacts
rwm rwm is offline
Newbie
 
Join Date: Jul 2007
Posts: 3
#3: Jul 10 '07

re: Opening outlook items from Access form


Quote:

Originally Posted by puppydogbuddy

try this:

1. create a shortcut for your Outlook Contacts folder on the desktop

2. Right click on an open area of the desktop

3. Select New / Shortcut

4. Enter in the path to your outlook program followed by outlook:contacts. Note the quotes are necessary:

Example
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE outlook:contacts


Thanks for the reply. That didnl;t work I'm afraid - just get a error message saying unable to open specified file.
puppydogbuddy's Avatar
Expert
 
Join Date: May 2007
Location: Florida
Posts: 1,915
#4: Jul 10 '07

re: Opening outlook items from Access form


Quote:

Originally Posted by rwm

Thanks for the reply. That didnl;t work I'm afraid - just get a error message saying unable to open specified file.

oops! forgot the quotes:
Example
"C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE" outlook:contacts
rwm rwm is offline
Newbie
 
Join Date: Jul 2007
Posts: 3
#5: Jul 11 '07

re: Opening outlook items from Access form


Didn't work either I'm afriad. I can get it to open outlook just using ther code in italics but it won's accept the outlook:contacts bit. Also I'm trying to do this as code rather than using a hyperlink field so I am using application.followhyperlink etc
Reply


Similar Microsoft Access / VBA bytes