Hyperlink to Access record/Form

[Peter]

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!

 

[JP]

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

 

[Peter]

Thanks JP, i will look into that...

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


.