Help with formula...

[Jackson Smith]

I am in the process of creating a message form in OL2000.
What I want to do is make an email address appear in
the "To:" field when certain checkboxes are checked. I
tried to do this by putting an IIf funcion (formula) in
the To field:
IIf([Checkbox1] = True, "(e-mail address removed)" ) & IIf
([Checkbox2] = True, "(e-mail address removed)" )

I have the "calculate this formula automatically" box
checked so it will run this formula when the form is being
filled out. The problem is that the sheet keeps getting
recalculated so the email address is showing up as text in
the To field instead of an email address. Is there an easy
work around for this? I am new at this and do not know VB
but I have copied scripts and used them. Any help would
be greatly appreciated.
Thanks,
Jackson

 

[Sue Mosher [MVP-Outlook]]

Things you need to know about formulas:

1) You can only write formulas for properties, not for controls. In other
words, you need to bind your check boxes to Outlook properties, using the
Value tab for each control, and use the name of the property in your
formula.

2) You can set a property value with a formula, but once you do that, the
user cannot enter data manually. I can't tell from your message whether this
is the way you want to To field to work.

It sounds like you've created the formula OK. It will appear as text until
Outlook automatically resolves the email address.