Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Merging Excel to Word

Geek News

Merging Excel to Word
Ness 4/27/2007 1:48:01 AM
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.
Re: Merging Excel to Word
"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 4/27/2007 6:30:51 AM
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

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

Ness wrote:
[Quoted Text]
> 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.


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net