If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word 2007 merge
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. |
#2
|
|||
|
|||
Word 2007 merge
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. |
#3
|
|||
|
|||
Word 2007 merge
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. |
Thread Tools | |
Display Modes | |
|
|