Automating address while adding contacts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top