Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
bsp131 bsp131 is offline
external usenet poster
 
Posts: 5
Default how to keep subject-verb agreement in merge document (word 2007)


--
bsp131
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default how to keep subject-verb agreement in merge document (word 2007)

You do it by including IF statements that conditionally insert the
appropriate verb/noun based on a field that indicates the quantity. For
example, consider the following text:

Dear «Name»,

We are enclosing your new widgets. We hope they meet your expectations.

Here, the "s" in widgets is really the following field:

{ IF { MERGEFIELD QUANTITY } = 1 "" "S"}

There is a data field named Quantity. If it's equal to 1, then "" (nothing)
is appended to the word "widget". If Quantity is not equal to 1, then an "s"
is appended to widget.

For the second sentence, we have a choice between "it meets" and "they
meet". This is handled with the following IF statement:

{ IF { MERGEFIELD QUANTITY } = 1 "it meets" "they meet"}

In Word 2007, you can insert an IF field by choosing Rules - If... Then...
Else in the Mailing ribbon tab.

--

Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"bsp131" wrote in message
...

--
bsp131


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
verb agreement in merge document bsp131 Mailmerge 1 August 12th 09 09:46 PM
Word 2007 Email Merge & Subject Line Arthur Shurn Mailmerge 2 August 8th 09 09:07 AM
How do I mail merge from Word to Outlook with merge subject field Alex Mailmerge 2 June 19th 09 07:40 AM
Can a document be broken down by parts of speech; noun, verb, etc summersunshine Microsoft Word Help 1 May 19th 08 11:40 AM
spell checking: false negative for "Subject-verb agreement" exotericist Microsoft Word Help 3 January 9th 08 11:47 PM


All times are GMT +1. The time now is 08:44 AM.

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"