Thanks for your help, but the reply is way over my head.

I've decided to do it a differnt way altogether.

I've exported a single contact as a .CSV file to get the field names
and I'm entering the data directly into Excel. (with autocomplete) so now I
just type au for Auckland International Airport and ai for Airport Oaks.

then save the xls as a .CSV and import back into Outlook.

Thanks again,

Al

"Sue Mosher [MVP-Outlook]" wrote:

You'd need to use the PropertyChange event -- see http://www.outlookcode.com/d/propsyntax.htm

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"estarriol33" wrote in message ...
Could you please give me an example of code?

I've done a small amount of excel macro's but I'm not too confident

Thanks

Al

"Sue Mosher [MVP-Outlook]" wrote:

Not without designing a custom form and writing code for it.


"estarriol33" wrote:

Hi All,

I have approximately 400 contacts to be added.

Most of them are in 1 of 2 areas.

1) Auckland International Airport
or 2) Airport Oaks

So when entering:

123 Test St
Auckland International Airport

is there any way to type in just the 123 test st then insert Auckland
International Airport on the next line down?

TIA

Al