Mail Merge With Two Columns

[JEngles]

I'm not sure how hard this question is, but it's got me baffled.

I have a user who wants to create a Word mail merge using an excel data source. Sure that's easy. But what happens when they want to divide the page up into columns and then add the same fields. As it runs through the data source, you get duplicates. So I though if you add the Next Record field, but all that does is make them out of snyc.

So my question is, how do you get column A to use even numbers and column B to use odd numbers when there both using the same source.

Am I missing something here? Any help would be most appreciated.

Cheers,
J

 

[macropod]

Hi J,

Probably the easiest way to do this is to run the merge for one record per page then change every other section break to a column break, starting with the first section break.

Cheers

[MS MVP - Word]

 

[SkipVought]

Hi,

Seems you're needing the NextRecord to get the two adjacent records.

Activate the MailMerge toolbar and find the ABC button. Toggle it to show the values. Make sure both names are displayed.

Turn on the macro recorder, and record this process...

Print

Next

Next

This advances the pointer two records.

Count the number to records in the source data and divide by 2

paste the recorded code within this loop

sub DoubleAdvance()
   dim i as integer
   for i = 1 to HalfTheRecordCount '<--Put half the record count here
     'paste your code in here

   next
   thisdocument.printout
end sub

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[JEngles]

Sorry Skip, I can't quite figure out what your saying there. So I'm guessing there is no easy way to say that in a 2 column document. The first field has record A, the second field has record B. Then on the second page the first field has record C and the second field has record D.

As it currently stands, the first field on the second page has record B.

I hope that made sense.

 

[SkipVought]

Did you use the NextRecord in column B to get BOTH names on the page?

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[JEngles]

Sorry guys, it turned out to be a REALLY simple thing in the end. What the problem was, is that when you use preview mail merge it looks all wrong. But when you print it, all works out. It makes no sense, but that's how it is.

All this time I never printed out because the preview looked wrong!

Thanks for all your help.