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/