I have been asked to research alternatives to the following existing procedures which use Access and Outlook Express.
The folks receive emails with information that relates to a specific record in their Access database. They select ALL the text in the email and copy it. They then search their records for that record, and paste the copied text into a memo field. They always put the most current information at the top of the memo.
Is this the most automation possible, or is there a more efficient means of “linking” (for lack of a better word) or encapsulating the email within an Access record?
TIA,
Ken