How do I link email text to an Access database?

[isaacmoats]

I'm creating a contacts database in Access. My emails are saved on Novel's GroupWise (web-based, not a client application). My database is on my hard drive and contains the usual: name, address, preferences, etc.

Is there some way to link the actual text of a customer's email to the entry in my database that deals with that customer (for example, field 1= name, field 2= phone number, field 3= actual text of email)? If the web source is a problem, would there be a way to do it if I imported the emails to Outlook or Outlook express?

 

[Ziggy1]

Outlook is pretty good for maintaining Contacts any way, but I know there might be more detail in your database customized to your needs.

You can also Import your e-mails into Access (into a new table), with with an Update query populate your E-mail address's to the matching contacts. The update query is a Join (Union) query that links the 2 tables via related fields. this will only work if the spelling( and data type) is the same between fields.

In the query design grid, drag the Email field for the table that you want to update, in the "Update To" line type the field to update from, but make sure it is fully qualified with square brackets like.... [yourTablename]![EmailfieldName]

Maybe not exactly what you ask, but just an idea.

Ziggy

 

[isaacmoats]

Thanks, Ziggy1, I'll give it a try!