Automating address while adding contacts
 

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

Automating address while adding contacts
 

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.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"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

Automating address while adding contacts
 

Not without designing a custom form and writing code for it.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"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

Automating address while adding contacts
 

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

Automating address while adding contacts
 

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