Merge with stacked fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leigh46137 - 20 May 2005 20:45 GMT

I am using MS Office 2000

I am trying to create a merge document that needs to list data on the page
like this:

Record 1, Field 1 Record 1, Field 2
Record 2, Field 1 Record 2 Field 2

Record 1, Field 3 Record 1, Field 4
Record 2, Field 3 Record 2, Field 4

The data lives in an Access database.

Any suggestions on how I can accomplish this??
(I've done a considerable amount VBA programming, so using code / macros
won't scare me)

Thanks!

Signature

Leigh46137

Reply to this Message

Peter Jamieson - 20 May 2005 22:38 GMT

The first thing to try is to save the values you need in bookmark variables
using SET fields and re-use them in REF fields,using a NEXT field to move
from record 1 to record 2, e.g.

{ SET r1field3 "{ MERGEFIELD field3 }"
}{ SET r1field4 "{ MERGEFIELD field4 }"
}{ MERGEFIELD field1 } { MERGEFIELD field2 }
{ NEXT }{ MERGEFIELD field1 } { MERGEFIELD field2 }

{ REF r1field3 }{ REF r1field4 }
{ MERGEFIELD field3 } { MERGEFIELD field4 }

All the {} need to be the special field braces you can insert using ctrl-F9

Peter Jamieson

>I am using MS Office 2000
>
[quoted text clipped - 14 lines]
>
> Thanks!

Reply to this Message

Leigh46137 - 21 May 2005 02:34 GMT

THANK YOU!!! I've been battling this merge for weeks! :)

Signature

Leigh46137

> The first thing to try is to save the values you need in bookmark variables
> using SET fields and re-use them in REF fields,using a NEXT field to move
[quoted text clipped - 29 lines]
> >
> > Thanks!

Reply to this Message