[Steve1445]

I am pulling data from an data source. I want to display data along the line
of company and then the employees the work for the company. I have no problem
pulling the data, only displaying it.

Top half of the page shows company bottom half all the associate employees.

My question revolves around the NEXT or NEXT IF fields. If I use NEXT the my
merge shows company XYZ and the associated employees, the bad part is other
employees who do not work for XYZ show up too.

So, I figured I need to be conditional, I defined the NEXT IF expression as
"NEXT IF ORG_ORGNAME = CUST_ORGNAME". Not sure that my syntax is entirely
correct. But it should look at the two fields where this data comes from (the
data is coming from an SQL joined table view query) and say well this does
not equal that, and stop showing the next companies employees. But in my case
all I get is the same record repeating over and over.

Must be overlooking something simple here. Thanks in advance.

[Doug Robbins - Word MVP]

It's not as simple as that, see:

http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/show...?Number=731107



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve1445" wrote in message
...
I am pulling data from an data source. I want to display data along the
line
of company and then the employees the work for the company. I have no
problem
pulling the data, only displaying it.

Top half of the page shows company bottom half all the associate
employees.

My question revolves around the NEXT or NEXT IF fields. If I use NEXT the
my
merge shows company XYZ and the associated employees, the bad part is
other
employees who do not work for XYZ show up too.

So, I figured I need to be conditional, I defined the NEXT IF expression
as
"NEXT IF ORG_ORGNAME = CUST_ORGNAME". Not sure that my syntax is entirely
correct. But it should look at the two fields where this data comes from
(the
data is coming from an SQL joined table view query) and say well this does
not equal that, and stop showing the next companies employees. But in my
case
all I get is the same record repeating over and over.

Must be overlooking something simple here. Thanks in advance.

[Steve1445]

Thanks Doug, I found the MS information as I continued to work, but the
tutorial really looks like what I need. Thanks for pointing me in the right
direction. Steve

"Doug Robbins - Word MVP" wrote:

It's not as simple as that, see:

http://cornell.veplan.net/article.aspx?&a=3815

or fellow MVP, macropod's tutorial on Catalogue/Directory Mailmerges at:

http://www.wopr.com/cgi-bin/w3t/show...?Number=731107



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve1445" wrote in message
...
I am pulling data from an data source. I want to display data along the
line
of company and then the employees the work for the company. I have no
problem
pulling the data, only displaying it.

Top half of the page shows company bottom half all the associate
employees.

My question revolves around the NEXT or NEXT IF fields. If I use NEXT the
my
merge shows company XYZ and the associated employees, the bad part is
other
employees who do not work for XYZ show up too.

So, I figured I need to be conditional, I defined the NEXT IF expression
as
"NEXT IF ORG_ORGNAME = CUST_ORGNAME". Not sure that my syntax is entirely
correct. But it should look at the two fields where this data comes from
(the
data is coming from an SQL joined table view query) and say well this does
not equal that, and stop showing the next companies employees. But in my
case
all I get is the same record repeating over and over.

Must be overlooking something simple here. Thanks in advance.