Word 2007 merge Steve1445 11/3/2008 8:03:03 PM 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.

Re: Word 2007 merge "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 11/3/2008 9:42:27 PM 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/showthreaded.pl?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" <Steve1445[ at ]discussions.microsoft.com> wrote in message news:A37E4A6D-36A9-444B-BF78-36A978E8684A[ at ]microsoft.com... [Quoted Text] >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.

Re: Word 2007 merge Steve1445 11/3/2008 10:06:05 PM 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: [Quoted Text] > 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/showthreaded.pl?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" <Steve1445[ at ]discussions.microsoft.com> wrote in message > news:A37E4A6D-36A9-444B-BF78-36A978E8684A[ at ]microsoft.com... > >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. > > >