eMail Data Connection

[CW]

I have a data connection that currently sends email based on the email
feild on a form. I'm trying expand it to use a function in the Data
Connection Wizard that will send an email based on the "email" field
on the form, provided, the individual is member of a division as
specied in the "division" field on the form, othwerwise, it should
just send to a specific address such as "(e-mail address removed)".

I understand how the contains function returns true or false, but I
need a function that will return the email address using logic such as
one uses in an Excel function where:

IIf("Division"=ABC Division",eMailField,"(e-mail address removed)")

Any help would be greatly appreciated, it just seems like the
functions in the data connection wizard are lacking, or I don't know
how to make it work correctly, or both.

Thanks

 

[Art]

Create a filed that is not displayed that has a default value of the default
address and then set rules where they select the division to set that field
to something different based on their selection.

 

[CW]

Thanks Art, I eventually ended up trying sdomething like that. I was
originally trying to make it all work through a formula the you
simplyy can in Access or Excel.

Thanks again for the suggestion.

Cheers!