TheMSsForum.com >> Entourage >> Batch edit Entourage contacts using Applescript & Excel

> 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_3229941619_767856
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit

I would like to use the Applescript provided by Microsoft at the link below
to edit a large database of contacts and then add them back into Entourage.
The script imports all the contacts and has a handy button to update any
edited entourage contacts EXCEPT that it will edit the phone numbers when it
first imports them.

http://www.microsoft.com/mac/resources/resources.aspx?pid=asforoffice

If I have a phone number in a contact as 0201234567 it will be imported to
excel as 201234567 (and also imported back to Entourage this way)
(However, if any numbers have a space within them then the ?0¹ at the front
is preserved.)

Any numbers with an international dialing code on them will lose the ?+¹
sign.

At a guess I would say Excel is reading the numbers as sums and removing
what it sees as unnecessary digits. I don¹t want to edit 3000 phone numbers,
so is there any way to use this script but make the import process treat all
cells as ?text¹ thus preserving inputted data exactly as it is written? It
seems like such an obvious bug but I couldn¹t see anywhere else other than
this forum to report it.

Thanks in advance :)

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

<HTML>
<HEAD>
<TITLE>Batch edit Entourage contacts using Applescript & Excel</TITLE>
</HEAD>
<BODY>
I wou=
ld like to use the Applescript provided by Microsoft at the link below to ed=
it a large database of contacts and then add them back into Entourage. &nbsp=
;The script imports all the contacts and has a handy button to update any ed=
ited entourage contacts EXCEPT that it will edit the phone numbers when it f=
irst imports them. 
 
<a href=3D"http://www.microsoft.com/mac/resources/resources.aspx?pid=3Dasforoff=
ice">http://www.microsoft.com/mac/resources/resources.aspx?pid=3Dasforoffice</=
a> 
 
If I have a phone number in a contact as 0201234567 it will be imported to =
excel as 201234567 (and also imported back to Entourage this way) 
(However, if any numbers have a space within them then the ‘0’ =
at the front is preserved.) 
 
Any numbers with an international dialing code on them will lose the &#8216=
;+’ sign. 
 
At a guess I would say Excel is reading the numbers as sums and removing wh=
at it sees as unnecessary digits. I don’t want to edit 3000 phone numb=
ers, so is there any way to use this script but make the import process trea=
t all cells as ‘text’ thus preserving inputted data exactly as i=
t is written? It seems like such an obvious bug but I couldn’t see any=
where else other than this forum to report it. 
 
Thanks in advance :) 
 
 

</BODY>
</HTML>

--B_3229941619_767856--

Top