Need help with formula

  • Thread starter Thread starter Jackson Smith
  • Start date Start date
J

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
 
I see nothing wrong with your formula. Outlook should resolve the address
text to an actual address when you send the message. Is that not happening?
 
Back
Top