Merging Excel to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ness - 27 Apr 2007 02:48 GMT

Data is in excel and am wanting to merge to word document that has two
separate tables.

If data says something (eg. Yes) then data goes into one table. If data
says (eg. No) then it goes into another table.

Reply to this Message

Graham Mayor - 27 Apr 2007 07:30 GMT

Put a conditional field in each table eg in table 1

{IF (Mergefield fieldname1} = "Yes" "{Mergefield fieldname2} etc"
in the other table
{IF (Mergefield fieldname1} = "No" "{Mergefield fieldname2} etc"

Signature

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

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

> Data is in excel and am wanting to merge to word document that has two
> separate tables.
>
> If data says something (eg. Yes) then data goes into one table. If
> data says (eg. No) then it goes into another table.

Reply to this Message