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 "email@companyxyz.com".

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,"email@companyxyz.com")

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