A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how to keep subject-verb agreement in merge document (word 2007)



 
 
Thread Tools Display Modes
  #1  
Old August 21st, 2009, 07:47 PM posted to microsoft.public.word.mailmerge.fields
bsp131
external usenet poster
 
Posts: 5
Default how to keep subject-verb agreement in merge document (word 2007)


--
bsp131
  #2  
Old August 21st, 2009, 09:10 PM posted to microsoft.public.word.mailmerge.fields
Herb Tyson [MVP]
external usenet poster
 
Posts: 3,614
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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.