Hyperlink to Access record/Form

  • Follow


Hi all, I am trying to solve this issue. Office 2007 / Outlook 2007 / Access 
2007
From a Access form I have a command button , send email, the DoCmd send 
object...How do I also create a hyperlink to this specific email, (the CC is 
one of my mail boxes), in order to be able to store the hyperlink in the 
access record, click on it and either open the sent email..or the specific 
email folder it resides..

Thanks!

0
Reply Utf 3/23/2010 3:38:02 PM

I don't think it's possible without the Outlook object model. You'd
need to instantiate Outlook, create and send the email, and capture
the MailItem.EntryID. Then use something like the TextBox.Click or
DblClick event to launch Outlook, find the email (using the entry ID)
and open it using MailItem.Display.

HTH,
JP

On Mar 23, 11:38=A0am, Peter <Pe...@discussions.microsoft.com> wrote:
> Hi all, I am trying to solve this issue. Office 2007 / Outlook 2007 / Acc=
ess
> 2007
> From a Access form I have a command button , send email, the DoCmd send
> object...How do I also create a hyperlink to this specific email, (the CC=
 is
> one of my mail boxes), in order to be able to store the hyperlink in the
> access record, click on it and either open the sent email..or the specifi=
c
> email folder it resides..
>
> Thanks!
0
Reply JP 3/24/2010 7:36:38 PM


Thanks JP, i will look into that...

"JP" wrote:

> I don't think it's possible without the Outlook object model. You'd
> need to instantiate Outlook, create and send the email, and capture
> the MailItem.EntryID. Then use something like the TextBox.Click or
> DblClick event to launch Outlook, find the email (using the entry ID)
> and open it using MailItem.Display.
> 
> HTH,
> JP
> 
> On Mar 23, 11:38 am, Peter <Pe...@discussions.microsoft.com> wrote:
> > Hi all, I am trying to solve this issue. Office 2007 / Outlook 2007 / Access
> > 2007
> > From a Access form I have a command button , send email, the DoCmd send
> > object...How do I also create a hyperlink to this specific email, (the CC is
> > one of my mail boxes), in order to be able to store the hyperlink in the
> > access record, click on it and either open the sent email..or the specific
> > email folder it resides..
> >
> > Thanks!
> .
> 
0
Reply Utf 3/25/2010 6:03:01 AM

2 Replies
609 Views

(page loaded in 0.057 seconds)

Similiar Articles:
















7/20/2012 4:02:39 AM


Reply: