Alabaster2100
IS-IT--Management
First, yes i have cross posted this to the vbscript 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!
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!