Solved

Hyperlink in Outlook that opens a Form in Access

Posted on 2002-07-03
5
248 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
your welcome... and i usually do check back often. ;)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

My experience with Windows 10 over a one year period and suggestions for smooth operation
Outlook Free & Paid Tools
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now