Merging Excel to Word

N

Ness

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

Graham Mayor

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"


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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Merge Excel file into Word Document 3
Excel --> Word 4
Page numbering with Merged Document and IF statements 1
Width of document changes when merging 1
Mail Merge Directory Conditional Page Break 0

Top