Title: Re: Entourage-Talk Digest - 08/15/06
whoops, sorry for that unclear message. Yes, I was trying to get a list of contacts from the delimited excel file into the Address book of Entourage. And yes that Import function worked perfectly. Right in front of my eyes, and I'd never used that function before. One thing that was odd: the window that comes up that allows you to map unmapped fields is an odd one. It took me awhile to figure out that you have to drag each unmapped field *to the right* of each map field. Not on top of it. If that window is not wide enough, this doesn't make any sense, so be sure to widen the window, and then an invisible space to the right of each mapped field opens up. That's where you drag the unmapped fields. But it worked perfectly. Thanks all.
From: "Entourage:mac Talk" <[email protected]>
Date: Tue, 15 Aug 2006 20:00:01 -0700
To: "Entourage:mac Talk" <[email protected]>
Subject: Entourage-Talk Digest - 08/15/06
From: Paul Berkowitz <[EMAIL PROTECTED]>
Date: Tue, 15 Aug 2006 12:43:50 -0700
Subject: Re: transferring excel database to Entourage 2004
On 8/15/06 12:09 PM, "Eddie Hargreaves" <[EMAIL PROTECTED]> wrote:
>> What exactly do you mean by "getting it into Entourage"? Do you not simply
>> want to to send the Excel file as an attachment that your recipients can save
>> and open?
>
> I assumed that Pitch wanted to get all of those names, addresses, etc. into
> Entourage's Address Book.
Oh.
In that case, the short answer do-it-yourself would be to save the Excel
file as a Tab-Delimited text file, then use the File/Import/Contacts from a
text file menu item in Entourage to import the text file, and use the
importer's capability to align the fields. (Make sure you retain the first
row of the Excel file with the "Name, Address, City, State, Zip,.." field
names.) The importer lets you drag these field names to align them with the
importer's version of the same fields.
If you have any problem with that, my Export-Import Entourage script set has
scripts for making adjustments within Excel and saving the file in a format
to be imported by the Contacts Import script, or using the "Other Contacts"
script to do the adjustment.
--
Paul Berkowitz
