Title: Re: Importing an address list from Excel
There's only one column in the Entourage address book for email: it displays the default email address, whether it's Home or Work.  The email address should not show up in either the Home o Work address section of the contact booklet - it shows up in the "Name and Email" area. There's nothing in the importer that can control whether it shows up with a "Home" or "Work" label, unfortunately: I suspect that it usually shows up as "Work: since that's the default. The importer only lists Email address by number - it can contain up to 13 of them. How do you have their columns listed in Excel? If you have a "Work Email" column and a "Home Email" column and you dragged "Work Email" in the importer to "Email 1" and "Home Email" to "Email 2", then I think you'd get the Work email address listed as Default if a contact has both - otherwise whichever one he has will be listed as default, of course. In neither case will it preserve your Home and Work column headings as labels since there's no way to make that correspondence in the importer.

There's nowhere in Entourage's Address Book  where email addresses are clickable links. It doesn't work that way - it has nothing to do with your import method. But there are lots of ways to select a contact and send an email: click once on it in the address book, send click the "New Message To" button in the toolbar, or select "New Message To" menu item in Contact menu, or right-clock (control-click) and select "New Message To" in the drop-down menu that appears. Or if you show the Preview Pane (View menu) or open the contact or the Summary page at front, just click the little yellow envelope icon to the left of the email address (any email address) in the Summary. Bingo.

Also you'll find that the auto-complete in a new email window works so well that you don't usually have to go to the address book anyway - just start typing 3 or 4 letters of first or last name and it will appear as (one of) the names to click on (press Return or Enter is best).

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

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



From: "Samuel D. Bays" <[EMAIL PROTECTED]>
Reply-To: "Entourage:mac Talk" <[email protected]>
Date: Tue, 28 Mar 2006 14:03:02 -0500
To: "Entourage:mac Talk" <[email protected]>
Conversation: Importing an address list from Excel
Subject: Re: Importing an address list from Excel

When I import an Excel database saved in CSV format, the email address appears under both Home AND Work email, but it isn't not clickable. That is, the email icon isn't the normal yellow "Send" icon, but rather a blue "Q" shaped icon that can not be invoked by clicking. If I click on the Send Mail icon in the Summary view, I get a blank for the email address.

Is there something yet to do in the import process to make these imports functional from the get go?

--
Sam Bays



From: Paul Berkowitz <[EMAIL PROTECTED]>
Reply-To: "Entourage:mac Talk" <[email protected]>
Date: Thu, 23 Mar 2006 07:47:19 -0800
To: Entourage Mac Talk <[email protected]>
Conversation: Importing an address list from Excel
Subject: Re: Importing an address list from Excel

On 3/23/06 7:31 AM, "David Ris" <[EMAIL PROTECTED]> wrote:

Good morning,

I am attempting to import an address list from that is currently stored on an Excel spreadsheet.

I believe I am following the correct procedure, but I am not succeeding in importing the addresses:
1.  I have converted the spreadsheet to CSV format.  
2.  Launch the import wizard in Entourage
3.  Choose import from a text file (tab or comma delimited)
4.   Select the file

At that point you are presented with a dialog box that has  2 columns.

The column on the right contains those fields that are "unmapped".   

The column on the left contains "mapped" fields.

The user is to drag the fields from the “unmapped” column to the “mapped” column

This is where it breaks down.

Dragging the "unmapped" fields does not  work ... after dragging, they just snap back to their original
position.

Am I missing a step in the process, or doing something else incorrectly?

It's a bit tricky. You have to drag them from the right column to the "right side" of the left column. Sometimes it takes a bit of fiddling around with them until they snap into place. If I remember correctly you can see a "highlight" area appear when you find the "sweet spot".

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

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


Reply via email to