HELP! What is used in excel to merge into designated Word Table Ce

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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Trina]

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

 

[Doug Robbins - Word MVP]

See the article "Control Word from Excel" at:

http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.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