Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Mail Merge with Multiple Columns

Oct 31, 2007 3:59PM PDT

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.

It ends up being the first field has record A, the second field has record B. Then on the second page the first field has record B and the second field has record C.

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

The good Dr.

Discussion is locked

- Collapse -
Work-around?
Oct 31, 2007 6:18PM PDT

Use a one-column master document. Mail-merge to another document, not directly to the printer. Then change the resulting document to contain 2 columns. It might be possible to get this scheme working satisfactory.

Kees

- Collapse -
I am visual
Oct 31, 2007 8:16PM PDT

Can you post an example of the output you are trying to get? I am not understanding the desired outcome.

Depending on what needs to happen after the merge, you could use a lable type layout.

- Collapse -
That's smart.
Nov 1, 2007 5:55AM PDT

A half page (vertical) custom sized label. Surely looks like columns when printed on a normal sheet of paper.

Kees