Solved

Hyperlink in Outlook that opens a Form in Access

Posted on 2002-07-03
5
271 Views
Last Modified: 2010-04-08
I want to create a hyperlink in Outlook, oh no, not any hyperlink, but one that is able to Open a Form inside of an Access database. First of all is this possible? and if Yes, HOW?
0
Comment
Question by:CyberAccess
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:Neo_mvps
ID: 7128602
programmatically....

user clicks a button or label and your click event does something like....

set objOutlook = CreateObject("Outlook.Application")
set objNamespace = objOutlook.GetNamespace("MAPI")
objNamespace.Logon "","", False, False

set colItems = objNamespace.GetDefaultFolder(4).Items
set objMsg = colItems.Add ("IPM.Note.Custom.Message.Class.Company")
objMsg.Display
set objMsg = Nothing
set colItems = Nothing
objNamespace.Logoff
Set objNamespace = Nothing
Set objOutlook = Nothing

0
 

Author Comment

by:CyberAccess
ID: 7137554
That is not what I am trying to do. I want to be inside of Outlook, and have a hyperlink in Outlook that opens a form in my Access database.
0
 
LVL 16

Accepted Solution

by:
Neo_mvps earned 150 total points
ID: 7137675
Then you would do something like this in VBScript behind an Outlook form.

Dim oAccess
Set oAccess = CreateObject("Access.Application")
oAccess.OpenCurrentDatabase "C:\database\TestDatabase.mdb"
oAccess.DoCmd.OpenForm "Test Form"
oAccess.Visible = True

0
 

Author Comment

by:CyberAccess
ID: 7138945
Thanks, I think i can handle the rest from here. You have helped me get a jump on things and Im off to a good start. Check back for more points because i might have more questions in the near future. Thanks Again.
0
 
LVL 16

Expert Comment

by:Neo_mvps
ID: 7139217
your welcome... and i usually do check back often. ;)
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
Outlook Free & Paid Tools
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question