Process Flow - Query design - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

kbfinn

New Member

Posts: 0

8/7/2006 4:49 PM

I need to create a process flow that to assist with auditing emergency contact details. I want to send an e-mail to each individual employee with a list of all the emergency contacts they have recorded in the system.
I can only seem to create a flow that sends the employee one email for each contact they have in the system.

Thanks for any help with this.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/7/2006 6:20 PM

You would use nested queries to accomplish this:
- The outer query would return the list of employees. In that query loop you would perform an inner query of contacts for that employee, and compose and send the email to that employee.

I've attached a picture of what it look like.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/7/2006 6:20 PM

You would use nested queries to accomplish this:
- The outer query would return the list of employees. In that query loop you would perform an inner query of contacts for that employee, and compose and send the email to that employee.

I've attached a picture of what it look like.

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

8/7/2006 6:20 PM

You would use nested queries to accomplish this:
- The outer query would return the list of employees. In that query loop you would perform an inner query of contacts for that employee, and compose and send the email to that employee.

I've attached a picture of what it should look like...