[schuey100]

I have about 100 emails (all in HTML format) and I wwant to export the data into an excel worksheet. The data consists of name, company, telephone number and email address.

Is there anyway of setting up some kind of rule or something that'll allow me to export the data without going through each one individually?

Thanks

[car1son]

I'd do this:

If not already, collect all the messages to export in a single Entourage folder. (Use Copy rather than Move if there's a need to keep them in previous location.)

Drag that Entourage folder onto the Finder. This exports all the messages in the folder into a single .mbox file.

Open the .mbox file in a text-editing utility to remove message headers and reduce the data to a comma-separated-calue (CSV) list. (I'd use emacs by preferences, but a BBEdit or Word Macro should suffice).

Import the CSV list to Excel.

You could also AppleScript it, if familiar with AppleScript.

[schuey100]

Thanks

I just gave that a go but there are so many headers etc that it's giving me a headache
eg:

with SMTP (2.1); 10-Jul-2003 15:57:53 +0100
X-VirusChecked: Checked
X-Env-Sender:
X-Msg-Ref: server-19.tower-1.messagelabs.com!1057848679!200944
X-StarScan-Version: 5.0.7; banner
Received: (qmail 15815 invoked from network); 10 Jul 2003 14:51:19 -0000
Received: from unknown (HELO scweb01.scrrce.net) (81..11)
by server-19.tower-1.messagelabs.com with SMTP; 10 Jul 2003 14:51:19 -0000
Received: from mail pickup service by scweb01.screencoet with Microsoft SMTPSVC;
Thu, 10 Jul 2003 15:51:15 +0100
Date: Thu, 10 Jul 2003 15:51:15 +0100
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_04A4_01C346FB.181FF8F0"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <SCWEB01QAOCop3wyv9k00001d5e@scweb01.screencot>
X-OriginalArrivalTime: 10 Jul 2003 14:51:15.0402 (UTC) FILETIME=[B67A8AA0:01C346F2]

This is a multi-part message in MIME format.

------=_NextPart_000_04A4_01C346FB.181FF8F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable





Thanks anyway.

Michael