Automating address while adding contacts

[estarriol33]

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

 

[estarriol33]

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]]

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

 

[Sue Mosher [MVP-Outlook]]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[estarriol33]

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