Help with formula...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jackson Smith - 25 Aug 2004 18:40 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Aug 2004 02:48 GMT

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.

Signature

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

>I am in the process of creating a message form in OL2000.
> What I want to do is make an email address appear in
[quoted text clipped - 14 lines]
> Thanks,
> Jackson

Reply to this Message