Linked Table to Outlook

[Brent]

I have a small database to maintain staff queries which come in by e-mail. I
have linked a table to my Outlook which is great as I want to be able to see
which e-mail or multiple e-mails are associated with each employee and query.

The problem I have is assigning the employee number to create the
relationship between the main form and e-mail sub form. Does this make sense
- am I going about it the right way? I had created an addtional column in
outlook to add the employee number - allowing that field to then be linked.
However it does not import into Access.

 

[Pete D.]

Although you can get these custom fields I have found it easier to search
and parse a normal field. One of the most popular is to assign a category
to the item but as your looking for employee you might try using email
address or deliminating an employee ID in a standard outlook item such as
memo. Using custom fields in outlook has spun off almost a whole new
industry which a quick search of Google will reveal. Biggest problem here
is you have little control over what the user puts in the response so a
standard category would give you some control. In access 2007 even
microsoft choose to use the email address for responses and nothing else.
For many spins on this check out
http://www.slipstick.com/
and good luck.

 

[Pete D.]

I should of mentioned, create a table with email address and employee id.
Use the category to pull this one/many emails and compare the email address
to the table for the employee ID. Now you can have a party with the email
information.

Although you can get these custom fields I have found it easier to search
and parse a normal field. One of the most popular is to assign a category
to the item but as your looking for employee you might try using email
address or deliminating an employee ID in a standard outlook item such as
memo. Using custom fields in outlook has spun off almost a whole new
industry which a quick search of Google will reveal. Biggest problem here
is you have little control over what the user puts in the response so a
standard category would give you some control. In access 2007 even
microsoft choose to use the email address for responses and nothing else.
For many spins on this check out
http://www.slipstick.com/
and good luck.

 

[Brent]

Hi Pete,

Thanks for that bit, it does help. However one thing I sometimes encounter
is that a query may be forwarded by e-mail to me by someone in HR. There for
the Employee ID > email address wouldn't be accurate. I have tried with
apend queries, however I don't think that would work. What about creating a
link to each item? I don't receive that many queries (at the moment) that I
need the process to be automated. I would quite happily link each individual
e-mail to the query form in Access.

Any further ideas helps.

Cheers!
--
....but its summer holidays, I shouldn''t be learning!

I should of mentioned, create a table with email address and employee id.
Use the category to pull this one/many emails and compare the email address
to the table for the employee ID. Now you can have a party with the email
information.