Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ness Ness is offline
external usenet poster
 
Posts: 7
Default Merging Excel to Word

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Merging Excel to Word

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:
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
merging from excel to word LERY616 Mailmerge 3 July 19th 06 08:00 PM
2.61 becomes 2.609999 when merging from Excel into Word. Lou Griffith Mailmerge 2 May 31st 06 06:52 AM
Merging Excel File into Word BigBuck98 Mailmerge 1 April 6th 06 07:39 AM
Merging excel with Word $ and % format is lost when merging Mailmerge 1 March 31st 05 05:04 PM
Merging from Excel into word Wim Willemse Mailmerge 3 March 31st 05 12:17 PM


All times are GMT +1. The time now is 01:23 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"