Importing excel data to Entourage address bool

[mrcrna]

I have a list of 450-some-odd names and addresses I'd like to import
into Entourage. I am unable to consistently map the import.
Sometimes the headers from Excel (in tab-delimited text) appear in the
mapping window, sometimes not. More often they don't.

Shouldn't I be able to map any column header into Entourage as a
custom field?

Thanks for any help.

Mark Ritter

 

[Diane Ross]

I have a list of 450-some-odd names and addresses I'd like to import
into Entourage. I am unable to consistently map the import.
Sometimes the headers from Excel (in tab-delimited text) appear in the
mapping window, sometimes not. More often they don't.

Shouldn't I be able to map any column header into Entourage as a
custom field?

Entourage doesn¹t handle HTML with grace. You can try this:

Copy in Excel and then use "Paste Specialaste as Picture" in Entourage.

 

[Michel Bintener]

Hi Mark,

here's what I would try: create a couple of contacts in Entourage by using
the data from the Excel file. When you've got a couple of contacts in
Entourage, click on File>Export, then select "Contacts to a list
(tab-delimited)". Open the resulting file in Excel and see in which order
the fields appear in that file. In your own Excel file, try to rearrange the
columns so that they match the sequence in the exported file, and make sure
that the headers are called by the same names Excel gives them in the
exported file. Then save that file as a tab-delimited text file and see if
Entourage now imports it properly.

I have a list of 450-some-odd names and addresses I'd like to import
into Entourage. I am unable to consistently map the import.
Sometimes the headers from Excel (in tab-delimited text) appear in the
mapping window, sometimes not. More often they don't.

Shouldn't I be able to map any column header into Entourage as a
custom field?

Thanks for any help.

Mark Ritter

--
Michel Bintener
Microsoft MVP
Office:Mac (Entourage & Word)

***Always reply to the newsgroup.***

 

[Mark Ritter]

What does pasting as a picture do and where do I paste to??

Mark

 

[Diane Ross]

In the Menu Bar under Tools, select to Insert --> Picture. This will insert
into the message body.

 

[Mark Ritter]

How does this help me? I want to take the excel file containing names,
addresses, phone numbers, emails, etc. and import that information into an
Entourage address book.
Mark

 

[John McGhie]

Hi Mark:

It doesn't. We misunderstood, I think.

You want File>Import in Entourage. Choose "From Text File" and then "Tab
separated values".

You need to save your Excel file out as tab-separated. I believe the import
utility enables you to re-map the fields on the way in (it's a long time
since I did this...)

I suggest tab-separated rather than comma separated, because your data may
have commas in it.

Cheers

How does this help me? I want to take the excel file containing names,
addresses, phone numbers, emails, etc. and import that information into an
Entourage address book.
Mark

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[Mark Ritter]

Problem solved!

Apparently, the column/header I couldn't import was formatted properly. It
contained numeric data...no formulas, no calculations, nothing but numeric
text. But, there were the little green comment indicators in each cell.

So, with some help in diagnosing, I changed the format of the column to
'Number' with no decimal places instead of 'General' or 'Text'.

Once the column was formatted correctly and the comment indicators
disappeared, the whole file mapped into Entourage like I've been hoping and
struggling to do for a week.

Berkowitz's script DID help. What a guy!