On or near 6/28/04 5:42 AM, Howard Holtzman at [EMAIL PROTECTED] observed: > Because Entourage has a lack of custom fields I store a lot of information > in the Contact Notes. Does anyone know the best way to move that info to a > data base program where it could be put into fields so that I could sort and > find specific pieces of data. > > Using Entourage 2004 on a PowerMac G4 and OS 10.3.4
First, you are aware that there _are_ eight custom fields plus two custom date fields, right? I assume that's not enough for you? If that is the case, the best way I can think of to move the data from notes to a database (like FileMaker Pro, or perhaps your needs are simple enough that something like iData Pro ($70, <http://www.idata2.com/status.html>) can handle it all. What you'll need to do is to export the data into a tab-delimited text file (tabs separating each field). To accomplish that, you will have to format the data in the Notes in a consistent way. For example (using fields I'm sure you have elsewhere, but so what, you get the idea): First Name: Allen Last Name: Watson Email1: [EMAIL PROTECTED] Address1: 123 Main Street Note that each field is on a separate line. If you do this, you could easily write a script that would extract the information and turn each Return into a Tab, with returns between each Note's record. If you wanted to go directly into FMP or iData Pro (not sure the latter is scriptable), the script could parse the field names and data, and construct the FMP record for you. -- To unsubscribe: <mailto:[EMAIL PROTECTED]> archives: <http://www.mail-archive.com/entourage-talk%40lists.letterrip.com/> old-archive: <http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
