Exporting my Contacts in Entourage in a CSV format

I am using MAC OSX and Entourage and would like to export my=20
contacts in a CSV format. I use Earthlink as my email provider and=20
when on the road do not have the same access to all my contacts/
addresses. The only way I was told (by Earthlink) to get all my =
contacts=20
from Entourage imported into my webmail was to have the exported=20
file converted somehow to a CSV format. Rght now, you can only=20
export contacts as a .txt file, I don't want to have to transfer all =
my=20
email back to my PC ( which I hate) so I can use Outlook, which does=20
let you export in various flie formats. Is there another way to export=20
from Entourage in the CSV format? Thanks.
Brian Bacchus

Paul
Wed Apr 14 04:06:02 CDT 2004

On 4/13/04 11:54 PM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,
"Brian Bacchus bmbacchus (remove this) @earthlink.net"
<anonymous@discussions.microsoft.com> wrote:

> I am using MAC OSX and Entourage and would like to export my
> contacts in a CSV format. I use Earthlink as my email provider and
> when on the road do not have the same access to all my contacts/
> addresses. The only way I was told (by Earthlink) to get all my contacts
> from Entourage imported into my webmail was to have the exported
> file converted somehow to a CSV format. Rght now, you can only
> export contacts as a .txt file, I don't want to have to transfer all my
> email back to my PC ( which I hate) so I can use Outlook, which does
> let you export in various flie formats. Is there another way to export
> from Entourage in the CSV format? Thanks.

There are many ways. Presumably if you have Entourage, you also have Excel.
Import the tab-delimited .txt file into Excel. (The best way to do that is
Data/Get External Data/Import Text File, but File/Open will also work OK.)
Then immediately Save As Cooma Separated Value file, and there you are.

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/toc.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - 2001 or X.
It's often impossible to answer your questions otherwise.

Brian
Wed Apr 14 16:29:14 CDT 2004

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3164808555_36509556
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

Paul,
Thank you very much. I should have thought of that. Thank you though.
Brian

> On 4/13/04 11:54 PM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,
> "Brian Bacchus bmbacchus (remove this) @earthlink.net"
> <anonymous@discussions.microsoft.com> wrote:
>
>> > I am using MAC OSX and Entourage and would like to export my
>> > contacts in a CSV format. I use Earthlink as my email provider and
>> > when on the road do not have the same access to all my contacts/
>> > addresses. The only way I was told (by Earthlink) to get all my contacts
>> > from Entourage imported into my webmail was to have the exported
>> > file converted somehow to a CSV format. Rght now, you can only
>> > export contacts as a .txt file, I don't want to have to transfer all my
>> > email back to my PC ( which I hate) so I can use Outlook, which does
>> > let you export in various flie formats. Is there another way to export
>> > from Entourage in the CSV format? Thanks.
>
> There are many ways. Presumably if you have Entourage, you also have Excel.
> Import the tab-delimited .txt file into Excel. (The best way to do that is
> Data/Get External Data/Import Text File, but File/Open will also work OK.)
> Then immediately Save As Cooma Separated Value file, and there you are.

--B_3164808555_36509556
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Exporting my Contacts in Entourage in a CSV format</TITLE>
</HEAD>
<BODY>
Paul, 
Thank you very much.  I should have thought of that.  Thank you t=
hough. 
Brian 
 
<BLOCKQUOTE>On 4/13/04 11:54 PM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,<=
BR>
"Brian Bacchus bmbacchus (remove this) @earthlink.net" 
<anonymous@discussions.microsoft.com> wrote: 
 
> I am using MAC OSX and Entourage and would like to export my 
> contacts in a CSV format.  I use Earthlink as my email provider a=
nd 
> when on the road do not have the same access to all my contacts/ 
> addresses.  The only way I was told (by Earthlink) to get all my =
contacts 
> from Entourage imported into my webmail was to have the exported 
> file converted somehow to a CSV format.  Rght now, you can only<B=
R>
> export contacts  as a .txt file,  I don't want to have to tr=
ansfer all my 
> email back to  my PC ( which I hate) so I can use Outlook, which =
does 
> let you export in various flie formats.  Is there another way to =
export 
> from Entourage in the CSV format?  Thanks. 
 
There are many ways. Presumably if you have Entourage, you also have Excel.=
 
Import the tab-delimited .txt file into Excel. (The best way to do that is<=
BR>
Data/Get External Data/Import Text File, but File/Open will also work OK.)<=
BR>
Then immediately Save As Cooma Separated Value file, and there you are. 
</BLOCKQUOTE> 
 

</BODY>
</HTML>

--B_3164808555_36509556--

Brian
Wed Apr 14 17:15:12 CDT 2004

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3164811313_36675859
Content-type: text/plain; charset="ISO-8859-1"
Content-transfer-encoding: 8bit

Paul,
I did what you suggested and was able to save the txt file in Excel
perfectly. Then I saved it as a CSV file (they give you 3 options
CSV(Windows) , CSV and CSV OS/2 DOS) I tried all three and saved them to my
desktop, but none of them worked. When I went to Earthlink to import the
files from my desktop, I got an error message that said, "The File
uploaded does not appear to be a valid Outlook CSV address book file." When
I check my Earthlink Webmail address book, there were new entries. Any
other suggestions?
Brian

> On 4/13/04 11:54 PM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,
> "Brian Bacchus bmbacchus (remove this) @earthlink.net"
> <anonymous@discussions.microsoft.com> wrote:
>
>> > I am using MAC OSX and Entourage and would like to export my
>> > contacts in a CSV format. I use Earthlink as my email provider and
>> > when on the road do not have the same access to all my contacts/
>> > addresses. The only way I was told (by Earthlink) to get all my contacts
>> > from Entourage imported into my webmail was to have the exported
>> > file converted somehow to a CSV format. Rght now, you can only
>> > export contacts as a .txt file, I don't want to have to transfer all my
>> > email back to my PC ( which I hate) so I can use Outlook, which does
>> > let you export in various flie formats. Is there another way to export
>> > from Entourage in the CSV format? Thanks.
>
> There are many ways. Presumably if you have Entourage, you also have Excel.
> Import the tab-delimited .txt file into Excel. (The best way to do that is
> Data/Get External Data/Import Text File, but File/Open will also work OK.)
> Then immediately Save As Cooma Separated Value file, and there you are.

--B_3164811313_36675859
Content-type: text/html; charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Exporting my Contacts in Entourage in a CSV format</TITLE>
</HEAD>
<BODY>
Paul, 
I did what you suggested and was able to save the txt file in Excel perfect=
ly.  Then I saved it as a  CSV file (they give you 3 options &#821=
1; CSV(Windows) , CSV and CSV OS/2 DOS)  I tried all three and saved th=
em to my desktop, but none of them worked.  When I went to Earthlink to=
import the files from my desktop, I got an error  message  that s=
aid, "The File uploaded does not appear to be a valid Outlook CSV addre=
ss book file."  When I check my Earthlink Webmail address book, th=
ere were new entries.  Any other suggestions? 
Brian 
 
<BLOCKQUOTE>On 4/13/04 11:54 PM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,<=
BR>
"Brian Bacchus bmbacchus (remove this) @earthlink.net" 
<anonymous@discussions.microsoft.com> wrote: 
 
> I am using MAC OSX and Entourage and would like to export my 
> contacts in a CSV format.  I use Earthlink as my email provider a=
nd 
> when on the road do not have the same access to all my contacts/ 
> addresses.  The only way I was told (by Earthlink) to get all my =
contacts 
> from Entourage imported into my webmail was to have the exported 
> file converted somehow to a CSV format.  Rght now, you can only<B=
R>
> export contacts  as a .txt file,  I don't want to have to tr=
ansfer all my 
> email back to  my PC ( which I hate) so I can use Outlook, which =
does 
> let you export in various flie formats.  Is there another way to =
export 
> from Entourage in the CSV format?  Thanks. 
 
There are many ways. Presumably if you have Entourage, you also have Excel.=
 
Import the tab-delimited .txt file into Excel. (The best way to do that is<=
BR>
Data/Get External Data/Import Text File, but File/Open will also work OK.)<=
BR>
Then immediately Save As Cooma Separated Value file, and there you are. 
</BLOCKQUOTE> 
 

</BODY>
</HTML>

--B_3164811313_36675859--

Paul
Wed Apr 14 19:59:49 CDT 2004

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3164810390_5073202
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit

OK. What they're looking for is the correct Outlook Header line (and perhaps
the correct Windows CRLF line-endings). I suggest you now get my shareware
scripts "Export-Import Entourage X" at

MacScripter.net <http://scriptbuilders.net/>

Use the Contacts-Groups Export from X script in the script menu to export
all contacts, then the EvX Contacts to Outlook script application in the
Outlook Converters folder to convert the Contact Export EvX.txt file (made
by the first script) to a CSV file that the earthlink importer will accept.
Read the Installation, script menu and Outlook (Export to Outlook) sections
of the ReadMe.

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: http://www.entourage.mvps.org/toc.html

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - 2001 or X.
It's often impossible to answer your questions otherwise.

From: Brian Bacchus <bmbacchus@earthlink.net>
Newsgroups: microsoft.public.mac.office.entourage
Date: Wed, 14 Apr 2004 18:15:12 -0400
Subject: Re: Exporting my Contacts in Entourage in a CSV format

Paul,
I did what you suggested and was able to save the txt file in Excel
perfectly. Then I saved it as a CSV file (they give you 3 options
CSV(Windows) , CSV and CSV OS/2 DOS) I tried all three and saved them to my
desktop, but none of them worked. When I went to Earthlink to import the
files from my desktop, I got an error message that said, "The File
uploaded does not appear to be a valid Outlook CSV address book file." When
I check my Earthlink Webmail address book, there were new entries. Any
other suggestions?
Brian

> On 4/13/04 11:54 PM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,
> "Brian Bacchus bmbacchus (remove this) @earthlink.net"
> <anonymous@discussions.microsoft.com> wrote:
>
>> > I am using MAC OSX and Entourage and would like to export my
>> > contacts in a CSV format. I use Earthlink as my email provider and
>> > when on the road do not have the same access to all my contacts/
>> > addresses. The only way I was told (by Earthlink) to get all my contacts
>> > from Entourage imported into my webmail was to have the exported
>> > file converted somehow to a CSV format. Rght now, you can only
>> > export contacts as a .txt file, I don't want to have to transfer all my
>> > email back to my PC ( which I hate) so I can use Outlook, which does
>> > let you export in various flie formats. Is there another way to export
>> > from Entourage in the CSV format? Thanks.
>
> There are many ways. Presumably if you have Entourage, you also have Excel.
> Import the tab-delimited .txt file into Excel. (The best way to do that is
> Data/Get External Data/Import Text File, but File/Open will also work OK.)
> Then immediately Save As Cooma Separated Value file, and there you are.

--B_3164810390_5073202
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Exporting my Contacts in Entourage in a CSV format</TITLE>
</HEAD>
<BODY>
OK. W=
hat they're looking for is the correct Outlook Header line (and perhaps the =
correct Windows CRLF line-endings). I suggest you now get my shareware scrip=
ts "Export-Import Entourage X" at 
 
 MacScripter.net <a href=3D"http://scriptbuilders.net/"><http://=
scriptbuilders.net/></a> 
 
Use the Contacts-Groups Export from X script in the script menu to export a=
ll contacts, then the EvX Contacts to Outlook  script application in th=
e Outlook Converters folder to convert the Contact Export EvX.txt file (made=
by the first script) to a CSV file that the earthlink importer will accept.=
Read the Installation, script menu and Outlook  (Export to Outlook) se=
ctions of the ReadMe. 
 
-- 
Paul Berkowitz 
MVP Entourage 
Entourage FAQ Page: <a href=3D"http://www.entourage.mvps.org/toc.html">http:/=
/www.entourage.mvps.org/toc.html</a> 
 
Please "Reply To Newsgroup" to reply to this message. Emails will=
be ignored. 
 
PLEASE always state which version of Entourage you are using - 2001 or X. I=
t's often impossible to answer your questions otherwise. 
 
 
<HR ALIGN=3DCENTER SIZE=3D"3" WIDTH=3D"95%">From: Brian Bacchus <bmbacc=
hus@earthlink.net> 
Newsgroups: microsoft.public.mac.office.entourage 
Date: Wed, 14 Apr 2004 18:15:12 -0400 
Subject: Re: Exporting my Contacts in Entourage in a CSV format 
 
Paul, 
I did what you suggested and was able to save the txt file in Excel perfect=
ly.  Then I saved it as a  CSV file (they give you 3 options &#821=
1; CSV(Windows) , CSV and CSV OS/2 DOS)  I tried all three and saved th=
em to my desktop, but none of them worked.  When I went to Earthlink to=
import the files from my desktop, I got an error  message  that s=
aid, "The File uploaded does not appear to be a valid Outlook CSV addre=
ss book file."  When I check my Earthlink Webmail address book, th=
ere were new entries.  Any other suggestions? 
Brian 
 
<BLOCKQUOTE><FO=
NT SIZE=3D"4">On 4/13/04 11:54 PM, in article 1=
970f01c421ed$46840740$a601280a@phx.gbl, 
"Brian Bacchus bmbacchus (remove this) @earthlink.net" 
<anonymous@discussions.microsoft.com> wrote: 
 
> I am using MAC OSX and Entourage and would like to export my 
> contacts in a CSV format.  I use Earthlink as my email provider a=
nd 
> when on the road do not have the same access to all my contacts/ 
> addresses.  The only way I was told (by Earthlink) to get all my =
contacts 
> from Entourage imported into my webmail was to have the exported 
> file converted somehow to a CSV format.  Rght now, you can only<B=
R>
> export contacts  as a .txt file,  I don't want to have to tr=
ansfer all my 
> email back to  my PC ( which I hate) so I can use Outlook, which =
does 
> let you export in various flie formats.  Is there another way to =
export 
> from Entourage in the CSV format?  Thanks. 
 
There are many ways. Presumably if you have Entourage, you also have Excel.=
 
Import the tab-delimited .txt file into Excel. (The best way to do that is<=
BR>
Data/Get External Data/Import Text File, but File/Open will also work OK.)<=
BR>
Then immediately Save As Cooma Separated Value file, and there you are. 
</BLOCKQUOTE><F=
ONT SIZE=3D"4"> 
 
 

</BODY>
</HTML>

--B_3164810390_5073202--

Brian
Thu Apr 15 02:01:38 CDT 2004

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3164842899_38525634
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

I HAVE DOWNLOADED AND WILL TRY LATER TODAY AND LET YOU KNOW. THANKS.
BRIAN

> OK. What they're looking for is the correct Outlook Header line (and perhaps
> the correct Windows CRLF line-endings). I suggest you now get my shareware
> scripts "Export-Import Entourage X" at
>
> MacScripter.net <http://scriptbuilders.net/>
>
> Use the Contacts-Groups Export from X script in the script menu to export all
> contacts, then the EvX Contacts to Outlook script application in the Outlook
> Converters folder to convert the Contact Export EvX.txt file (made by the
> first script) to a CSV file that the earthlink importer will accept. Read the
> Installation, script menu and Outlook (Export to Outlook) sections of the
> ReadMe.

--B_3164842899_38525634
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Exporting my Contacts in Entourage in a CSV format</TITLE>
</HEAD>
<BODY>
I HAVE DOWNLOADED AND W=
ILL TRY LATER TODAY AND LET YOU KNOW.  THANKS. 
BRIAN 
 
<BLOCKQUOTE>OK. What they're looking for is the correct Outlook Header=
line (and perhaps the correct Windows CRLF line-endings). I suggest you now=
get my shareware scripts "Export-Import Entourage X" at 
 
 MacScripter.net <a href=3D"http://scriptbuilders.net/"><http://scrip=
tbuilders.net/></a> 
 
Use the Contacts-Groups Export from X script in the script menu to export a=
ll contacts, then the EvX Contacts to Outlook  script application in th=
e Outlook Converters folder to convert the Contact Export EvX.txt file (made=
by the first script) to a CSV file that the earthlink importer will accept.=
Read the Installation, script menu and Outlook  (Export to Outlook) se=
ctions of the ReadMe. 
</BLOCKQUOTE><SPAN=
STYLE=3D'font-size:12.0px'> 
 

</BODY>
</HTML>

--B_3164842899_38525634--

Mickey
Sat Apr 17 19:41:42 CDT 2004

On 4/14/04 1:54 AM, in article 1970f01c421ed$46840740$a601280a@phx.gbl,
"Brian Bacchus bmbacchus (remove this) @earthlink.net"
<anonymous@discussions.microsoft.com> wrote:

> I am using MAC OSX and Entourage and would like to export my
> contacts in a CSV format. I use Earthlink as my email provider and
> when on the road do not have the same access to all my contacts/
> addresses. The only way I was told (by Earthlink) to get all my contacts
> from Entourage imported into my webmail was to have the exported
> file converted somehow to a CSV format.

You were given incorrect information. You do not need to export your
information to CSV format to import Entourage data into EarthLink WebMail.
Note: You do need OS X 10.2+ and EarthLink TotalAccess 2004 (free) for the
other method. <http://www.earthlink.net/home/software/mac/>.

Begin by exporting your contacts to Apple's Address Book application. You
can do that by a variety of methods, all described here:
<http://www.entourage.mvps.org/faq/faqs.html#Anchor-127>
(I would recommend Option #1 or Option #4)

Then, install and open EarthLink TotalAccess 2004. Click the envelope icon,
and press the "Sync" button. That will upload all of your contacts to
EarthLink WebMail.

--
Mickey Stevens (Microsoft MVP for Office:mac)
PowerPoint FAQ featuring PowerPoint:mac: <http://www.pptfaq.com/>
Entourage Help Page: <http://www.entourage.mvps.org/toc.html>

Exporting my Contacts in Entourage in a CSV format

Re: Exporting my Contacts in Entourage in a CSV format by Paul

Re: Exporting my Contacts in Entourage in a CSV format by Brian

Re: Exporting my Contacts in Entourage in a CSV format by Brian

Re: Exporting my Contacts in Entourage in a CSV format by Paul

Re: Exporting my Contacts in Entourage in a CSV format by Brian

Re: Exporting my Contacts in Entourage in a CSV format by Mickey