Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OL2003 VBScript on custom Form

Status
Not open for further replies.

Alabaster2100

IS-IT--Management
Apr 7, 2001
26
CA
First, yes i have cross posted this to the Exchange2003 page as it is a very VBS question, but I need outlook specific responses so heres my problem.

Env: OL2003 / Ex2003SBS

I have a contacts folder of 1500 people.
Each has a fax number as +1(555)123-4567
My exchange connected fax program needs FAX:+1(555)123-4567
I have customized the form to add a "fax-merge" field which is Inital valued-auto to "FAX:"+[Fax Number]
So far this works great, new contacts get a fax-merge number based on their fax number and any numbers I edit auto update.
Now for the 1500 contacts I already have, I need to update the fax-merge field without going into each one individually.
I tried making a VBScript that would open each contact, copy the fax number to a variable, clear the fax number and then set the fax number back using the variable. Save the contact and move on to the next.
However, this does not seem to have any bering on the fax-merge field.
From all my diging, VBSript does not seem to have a "refresh" or "requery" command.
So I'm stumped...
Am I missing something or am I making this way more complicated then it needs to be.

Thanks

Peter

~~~~~~~~~~~~~~~~~~~~~
Peter
-Self educated Geek-
If it can be fixed...
I can break it!
 
you might be better off the in vba forum.
you should be able to loop through all the contacts in a folder
then you should be able to update a property of the said contact

the vbscript you suggested all seems reasonable to me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top