Query data from Access, using an Infopath form

[Sephiroth]

I am currently creating a form, using InfoPath 2007, to populate a form
library on sharepoint 2007. This is all very new to me and although i have
spent a month working on this form (and the logistics behind the scene), i
just hit a wall where even IT can't help me out.

My problem is this: Using Designer 2007, i am trying to automate a workflow
to email people according to what information is filled out on the form. I
can populate the sharepoint sites, that's not a problem. What i can't do is
get Designer to help me construct a logic sequence that will send an email to
the address from a field on the form.

Another difficulty i am having is to get infopath to query an email name on
an Access DB, after determining the relationship between two tables.

SO: can't get infopath form to query email info when a drop down field
selects something out of a linking access DB; and can't automate Designer's
workflow to email a recipient based on the email address that was entered by
the previous form user.

Please help me out!!!

Thanks,

Giuseppe

 

[S.Y.M. Wong-A-Ton]

To lookup the email address, you can use a technique similar to the one
described in this article:
http://www.bizsupportonline.net/inf...ook-up-data-sharepoint-list-rules-filters.htm

To access the email address in SharePoint Designer, you have to promote the
email field
(http://www.bizsupportonline.net/blog/2009/02/how-to-retrieve-infopath-form-data-sharepoint-workflow/) when you publish the InfoPath form template.

Then in SharePoint Designer, create a workflow that runs when a new item is
created in the Form Library. You can use the Send an Email workflow action to
send an email. The email field from the InfoPath form should be available as
a field on the Current Item when specifying the email address to use to send
the email.