Automating address while adding contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

estarriol33 - 28 Mar 2007 00:07 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Mar 2007 01:11 GMT

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

Signature

Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Hi All,
>
[quoted text clipped - 16 lines]
>
> Al

Reply to this Message

estarriol33 - 28 Mar 2007 01:10 GMT

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

> Not without designing a custom form and writing code for it.
>
[quoted text clipped - 18 lines]
> >
> > Al

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Mar 2007 14:02 GMT

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

Signature

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

> Could you please give me an example of code?
>
[quoted text clipped - 5 lines]
>
>> Not without designing a custom form and writing code for it.

>> > Hi All,
>> >
[quoted text clipped - 16 lines]
>> >
>> > Al

Reply to this Message

estarriol33 - 28 Mar 2007 23:42 GMT

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

> You'd need to use the PropertyChange event -- see http://www.outlookcode.com/d/propsyntax.htm
>
[quoted text clipped - 28 lines]
> >> >
> >> > Al

Reply to this Message