Hi,
I am working in the office and I am developing a program on Ms Access for
our recruiter. She wants to see e-mail history with the person she wants to
recruit so she can track what has happened during recruiting process. I have
a field that holds email address on the form. I want to take the email
address from this field and go to outlook send emails folder and find all the
email addresses that match with the email address in the field and show these
emails as links on the access form. When she clicks this email link outlook
will open this email and she can read what she received from that person in
the past.
--
Thanks

Do you want to use hyperlinks on your Access form, one for each e-mail? I
woudn't recommend this approach. What I would recommend is either of these:

1. Populate a listbox on the form with the subject line of all related
e-mails, with the EntryID value for the individual MailItem objects stored in
a hidden column

You can use the Restrict method of the Items collection from the Sent Items
folder (MAPIFolder.Items.Restrict) to filter messages for a particular
recipient ("[To] = 'John Doe'", or "[To] = '"). You may
need to use the AdvancedFind method to use DASL queries for more fine control
over the recipient values.

2. Put a button on your access form - "Show Sent Emails" that will create a
Search Folder on the fly with the criteria you set, and then open Outlook to
display it.


--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Appache" wrote:

Hi,
I am working in the office and I am developing a program on Ms Access for
our recruiter. She wants to see e-mail history with the person she wants to
recruit so she can track what has happened during recruiting process. I have
a field that holds email address on the form. I want to take the email
address from this field and go to outlook send emails folder and find all the
email addresses that match with the email address in the field and show these
emails as links on the access form. When she clicks this email link outlook
will open this email and she can read what she received from that person in
the past.
--
Thanks