Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.mac.office.word,microsoft.public.word.mailmerge.fields
John McGhie [MVP Word, Word Mac] John McGhie [MVP Word, Word Mac] is offline
external usenet poster
 
Posts: 11
Default Data Merge - Excel Records to Word Table

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 he 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,

wrote in message
ps.com...
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)



  #2   Report Post  
Posted to microsoft.public.mac.office.word,microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Data Merge - Excel Records to Word Table

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

"John McGhie [MVP Word, Word Mac]" wrote in message
...
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 he 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,

wrote in message
ps.com...
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)





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Merge - Excel Records to Word Table Columns NOT Rows eagleshout Mailmerge 1 May 14th 07 07:54 AM
merge records are using too many decimal spaces when I use records from an Excel Database aspen Mailmerge 1 March 23rd 07 09:12 PM
Not merging all records from an Excel data source CMEC Mailmerge 3 December 8th 06 06:41 PM
Update Excel table in Word automatically from data in Excel yvonnedemulder Tables 1 December 6th 05 06:49 PM
Form Letter In Word / Data Source in Excel ... cannot edit records John Mailmerge 4 May 20th 05 10:33 PM


All times are GMT +1. The time now is 11:55 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"