Help with formula...

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, "joesmoe@none.com" ) & IIf
([Checkbox2] = True, "sallysmoe@nothing.com" )

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

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.

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


"Jackson Smith" <anonymous@discussions.microsoft.com> wrote in message
news:d54901c48aca$a720d470$a601280a@phx.gbl...
>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, "joesmoe@none.com" ) & IIf
> ([Checkbox2] = True, "sallysmoe@nothing.com" )
>
> 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