[Trina]

What is used in an excel file and Word Table merge document to designate what
table row/column the data should drop into during a merge?

The word table is 3 x 3, and each cell has a label (1A, 2A, 3A, 1B, 2B, 3B,
1C, 2C, 3C)

The excel spreadsheet will have a column with one of those 9 labels to
identify it, along with 3 other fields. The 3 other fields are what needs to
be in the table. The labels identify what row/column the data needs to be
dropped into.

Help, desperately frustrated!

Thanks!

--
Trina

[Graham Mayor]

You asked this a couple of hours earlier!
The merge fields that relate to your data are used to determine where the
data is placed e.g. If you have a column A1 in your data source and you want
that information in cell A1 put the { Mergefield A1 } in that cell. However
it appears that you may want to create separate lists in each cell and that
is not possible with mail merge.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Trina wrote:
What is used in an excel file and Word Table merge document to
designate what table row/column the data should drop into during a
merge?

The word table is 3 x 3, and each cell has a label (1A, 2A, 3A, 1B,
2B, 3B, 1C, 2C, 3C)

The excel spreadsheet will have a column with one of those 9 labels to
identify it, along with 3 other fields. The 3 other fields are what
needs to be in the table. The labels identify what row/column the
data needs to be dropped into.

Help, desperately frustrated!

Thanks!

[Trina]

Is there a different Microsoft program that I should look into?
(Sorry about the duplicate, I tried to delete that question.)

"Graham Mayor" wrote:

You asked this a couple of hours earlier!
The merge fields that relate to your data are used to determine where the
data is placed e.g. If you have a column A1 in your data source and you want
that information in cell A1 put the { Mergefield A1 } in that cell. However
it appears that you may want to create separate lists in each cell and that
is not possible with mail merge.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Trina wrote:
What is used in an excel file and Word Table merge document to
designate what table row/column the data should drop into during a
merge?

The word table is 3 x 3, and each cell has a label (1A, 2A, 3A, 1B,
2B, 3B, 1C, 2C, 3C)

The excel spreadsheet will have a column with one of those 9 labels to
identify it, along with 3 other fields. The 3 other fields are what
needs to be in the table. The labels identify what row/column the
data needs to be dropped into.

Help, desperately frustrated!

Thanks!

[Doug Robbins - Word MVP]

See the article "Control Word from Excel" at:

http://www.word.mvps.org/FAQs/InterD...WordFromXL.htm

What you are trying to do however is not straight forward but it could be
done using a macro.

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

"Trina" wrote in message
...
Is there a different Microsoft program that I should look into?
(Sorry about the duplicate, I tried to delete that question.)

"Graham Mayor" wrote:

You asked this a couple of hours earlier!
The merge fields that relate to your data are used to determine where the
data is placed e.g. If you have a column A1 in your data source and you
want
that information in cell A1 put the { Mergefield A1 } in that cell.
However
it appears that you may want to create separate lists in each cell and
that
is not possible with mail merge.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Trina wrote:
What is used in an excel file and Word Table merge document to
designate what table row/column the data should drop into during a
merge?

The word table is 3 x 3, and each cell has a label (1A, 2A, 3A, 1B,
2B, 3B, 1C, 2C, 3C)

The excel spreadsheet will have a column with one of those 9 labels to
identify it, along with 3 other fields. The 3 other fields are what
needs to be in the table. The labels identify what row/column the
data needs to be dropped into.

Help, desperately frustrated!

Thanks!