Email added to a record

P

PaulR

I have a database of Vendors and require to add any email communication I
have had to the relevant record in the database. How can I do this please???
 
M

[MVP] S.Clark

The email itself, or just the body text? I wouldn't store the email in the
database, as that's what Outlook(et al) was designed. $0.02.

I make a table that has the following fields:

NoteID
NoteTimestamp
NoteType (Email, Phone, Fax, TM, etc)
Note (Memo)
ForeignKeyID

So, if a customer contacts you, you can log the Date/Time, specify how they
contacted you(That's the type), and then put anything text-wise that you
want into the memo field. That way it's searchable too. The foreignkeyID
in this case would be the CustomerID.
 
Top