I'm using O2003. I added Combination field and for each new contact
it works fine. The trouble I'm having is until I open a current
contact and edit it, the value of #ERROR appears in the field. I've
tried to complete a group update so the data changes (city, title,
etc.), but no luck. I have around 10,000 names so editing each one
manually is not something to look forward to.

Any ideas to complete the group update so the contact gets updated and
the #ERROR is removed? I also tried to apply an old form and then
reapply my custom form. No luck.

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [First Name]:

Thanks.

Shawn

On Jul 30, 10:52*am, srm wrote:
I'm using O2003. *I added Combination field and for each new contact
it works fine. The trouble I'm having is until I open a current
contact and edit it, the value of #ERROR appears in the field. *I've
tried to complete *a group update so the data changes (city, title,
etc.), but no luck. I have around 10,000 names so editing each one
manually is not something to look forward to.

Any ideas to complete the group update so the contact gets updated and
the #ERROR is removed? *I also tried to apply an old form and then
reapply my custom form. *No luck.

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [First Name]:

Thanks.

Shawn

After trying some items, now I always get the #ERROR. I edit the data
for a contact, see it being updated in the field (while I'm still in
the contact), save the contact, and when I open the contact again, the
field reflects #ERROR again.

Hopefully its something simple that I'm missing.

Shawn

The problem is that the formula in that field is returning an error because
the values in the fields that make up the formula calculation return an
invalid result. You can include better logic in the formula to test for
invalid results and return a blank/null value; the IIF function is a good
candidate.

--
Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
President
Collaborative Innovations
- Try Picture Attachments Wizard 2.0 For Microsoft Outlook -
- Take your SharePoint content offline -
- More info: http://www.collaborativeinnovations.ca -
Blog: http://blogs.officezealot.com/legault

"srm" wrote in message
...
On Jul 30, 10:52 am, srm wrote:
I'm using O2003. I added Combination field and for each new contact
it works fine. The trouble I'm having is until I open a current
contact and edit it, the value of #ERROR appears in the field. I've
tried to complete a group update so the data changes (city, title,
etc.), but no luck. I have around 10,000 names so editing each one
manually is not something to look forward to.

Any ideas to complete the group update so the contact gets updated and
the #ERROR is removed? I also tried to apply an old form and then
reapply my custom form. No luck.

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [First Name]:

Thanks.

Shawn

After trying some items, now I always get the #ERROR. I edit the data
for a contact, see it being updated in the field (while I'm still in
the contact), save the contact, and when I open the contact again, the
field reflects #ERROR again.

Hopefully its something simple that I'm missing.

Shawn

On Aug 1, 11:34*am, "Eric Legault [MVP - Outlook]"
wrote:
The problem is that the formula in that field is returning an error because
the values in the fields that make up the formula calculation return an
invalid result. *You can include better logic in the formula to test for
invalid results and return a blank/null value; the IIF function is a good
candidate.

--
Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
President
Collaborative Innovations
- Try Picture Attachments Wizard 2.0 For Microsoft Outlook -
- Take your SharePoint content offline * * * * * * * * * * -
- More info:http://www.collaborativeinnovations.ca* * * *-
Blog:http://blogs.officezealot.com/legault

"srm" wrote in message

...

On Jul 30, 10:52 am, srm wrote:
I'm using O2003. I added Combination field and for each new contact
it works fine. The trouble I'm having is until I open a current
contact and edit it, the value of #ERROR appears in the field. I've
tried to complete a group update so the data changes (city, title,
etc.), but no luck. I have around 10,000 names so editing each one
manually is not something to look forward to.

Any ideas to complete the group update so the contact gets updated and
the #ERROR is removed? I also tried to apply an old form and then
reapply my custom form. No luck.

[Full Name]
[Job Title]
[Company]
[Business Address]

Dear [First Name]:

Thanks.

Shawn

After trying some items, now I always get the #ERROR. *I edit the data
for a contact, see it being updated in the field (while I'm still in
the contact), save the contact, and when I open the contact again, the
field reflects #ERROR again.

Hopefully its something simple that I'm missing.

Shawn

Eric:

Thank you. I will give that a try. I appreciate your help.