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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trina - 15 Apr 2008 16:59 GMT

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!

Signature

Trina

Reply to this Message

Graham Mayor - 16 Apr 2008 06:25 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> 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
[quoted text clipped - 11 lines]
>
> Thanks!

Reply to this Message

Trina - 16 Apr 2008 16:51 GMT

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

> You asked this a couple of hours earlier!
> The merge fields that relate to your data are used to determine where the
[quoted text clipped - 18 lines]
> >
> > Thanks!

Reply to this Message

Doug Robbins - Word MVP - 16 Apr 2008 20:58 GMT

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.

Signature

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

> Is there a different Microsoft program that I should look into?
> (Sorry about the duplicate, I tried to delete that question.)
[quoted text clipped - 24 lines]
>> >
>> > Thanks!

Reply to this Message