Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jenkusi jenkusi is offline
external usenet poster
 
Posts: 2
Default Nested Merge field saves as merged with first record in excel

I am trying to merge a Word document with an excel file where the excel file
has numbers 1,2,3 which I want changed to words when merged with the Word
Document. I am able to make the merge work but the merge fields always saves
as merged with the first record in the excel file even if I do not complete
the merge. How do I get Word to save with the merge fields remaining as
merge fields and not taking on the values of the first record in excel. The
merge field that I am using is the following:
{IF {MERGEFIELD "Demonstrates"}="3" "Exceeding Expectations" {IF {MERGEFIELD
"Demonstrates"}="2" "Meeting Expectations" {IF {MERGEFIELD
"Demonstrates"}="1" "Not Meeting Expectations" {MERGEFIELD "Demonstrates"}}}}
 
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
Merge with Excel with multiple Record Alan Tang Mailmerge 3 February 20th 06 10:34 AM
IF then with merged date field from excel Holly Mailmerge 3 January 14th 06 07:05 AM
mail merge from excel-date in excel January 1, 2005 -merged dbase. Elaine Ballon Mailmerge 1 December 23rd 05 08:31 AM
Next Record merge field with text boxes Hand Prints Mailmerge 2 October 27th 05 07:32 AM
Cannot go to last record in excel-word merged document Earl Microsoft Word Help 1 September 19th 05 09:29 PM


All times are GMT +1. The time now is 11:47 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"