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
|
|||
|
|||
Merging results of an access query into an existing doc
Hello I am trying to get the results of a Access Query to mail merge into an exisiting form. My query brings data based on the following fields WORK_ORDER_NUMBER SITE_ADDRESS DEVELOPER SCOPE_OF_WORKS DETAILS PLOT Basically, a work order will be associated with a plot and may be associated with 1 or more plots. Therefore, work order 6798 may be associated with plot 1,2 and 4. Thus when the query runs, work order 6798 will show up 3 times I have managed to get the folloing to work in a new blank document )it is based on a the formula from KB181730) {If {MergeSeq} = "1" "{Mergefield developer} {mergefield site_address}¶ {mergefield work_order_number}{mergefield scope_of works}{mergfield details}¶ " ""}{Set WO1 {Mergefield worl_order_number}}¶ {If {WO1} {WO2}"¶ "{Mergefield developer} {mergefield site_address}¶ {mergefield work_order_number}{mergefield scope_of works}{mergfield details}¶ {Mergefield plot}"¶ {Mergefield plot}"}{Set WO2 {Mergefield work_order_number}}¶ This merges into a new document with the data like this My Homes Estate 1, Anytown 45678 LV Breech Joint near plot 76 - to liven plot 81 only - (95-185wf) 81 My Homes Estate 1, Anytown 45679 LV Breech Joint o/s 76 to liven plot 76 only - 76 My Homes Estate 1, Anytown 45680 Double Service Breech 37/82 37 82 My Homes Estate 2, Anytown , Warrington 50372 Double Service Breech Plots 36/37 37 36 What I am having difficulty with is trying to get the data to fit on a two paged document ie, where to place the merge fields and "if" and "set" statements accordingly. The information re plots needs to go on a page two of the document. I can e-mail a version of the document if needs be! Any assistance or guidance would be greatly appreciated!!! ------------------------------------------------ ~~ Message posted from http://www.WordForums.com/ |
Thread Tools | |
Display Modes | |
|
|