Data Merge - Excel Records to Word Table

[eagleshout]

I'm either in over my head or I'm triying to accomplish the
impossible. I want to merge partial fields from an Excel list into
Word table cells. The standard direction of the record placement seems
to be horizontally (within row cells and across columns.) I want the
data to be placed vertically so I can place a <<next record>> at the
top of each column and have the data flow vertically from top to
bottom and then start a new record at the top of the next column

Can anyone suggest a practical solution?

tags:
data merge fields fill table vertical columns not horizontal (across
rows)

 

[John McGhie [MVP Word, Word Mac]]

You will need to do that as two steps.

A mail merge always injects a section break at the end of each record
(assuming you want a new letter). When you are performing a data merge,
that becomes complex.

I have cross-posted into the group that specialises in datamerge. The bent
souls in there do this for a living. Say "Hi" to them for me, and don't
forget to tell them you are working on a Macintosh.

Note: We actually need to confirm which version of Word, which Operating
System, and their patch levels that you are using. Things move fast in the
computer world and the specialists in here need that information to ensure
that their answer fits your circumstance.

Cheers

--

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]

 

[Doug Robbins - Word MVP]

It is not possible to tell exactly what you want to achieve. If the data
that you want to appear going down the column is from the various fields in
the one record, then simply arrange those fields in the configuration that
you want in a single cell of a table, or if you want the data from
individual fields to appear in separate cells, arranged vertically, format
your document with as many columns as you want columns of data and then
insert a single column table in each of those columns and insert the merge
fields into the cells of those tables with a Next Record field before the
first merge field in the second and subsequent columns.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP