Reply
 
Thread Tools Display Modes
  #1   Report Post  
corquando corquando is offline
Junior Member
 
Posts: 2
Default Blank as True Text in Mail Merge

Howdy, experts.

I wish to create envelopes that have the country name printed only if it isn't "USA." Because of the nature of the database source, the "Address Block" function will not work; the address lines are repeated and reformatting that would be problematic at best, so the "Address Block" function is out; trust me on this.

Here's the code:
Code:
IF {MERGEFIELD Country}="USA" "" {MERGEFIELD Country}
What it returns in all cases is "Country}" regardless of field content.


This renders the Edit Field function unsuable, as in grays out the OK button:
Code:
{IF {MERGEFIELD Country}="USA" "" {MERGEFIELD Country}}
As does this:
Code:
{IF {MERGEFIELD Country}="USA" "" "{MERGEFIELD Country}"}

And these do nothing different at all:
Code:
IF {MERGEFIELD Country}="USA" "" "{MERGEFIELD Country}"

IF {MERGEFIELD Country}="USA" "{}" "{MERGEFIELD Country}"
What overly simple syntactical error(s) am I committing?

Thanks in advance.

Last edited by corquando : August 15th 11 at 03:29 PM
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
Mail Merge Blank....? Confused87 Mailmerge 1 September 23rd 09 04:41 PM
Mail Merge Using Contacts from Mail - Blank Lines ALJ1 Mailmerge 1 May 16th 08 03:36 PM
How to use mail merge to send out a form with blank text fields? Gwendolyn Mailmerge 1 November 17th 05 05:16 AM
Merge data if database checkbox field is True Terry B via OfficeKB.com Mailmerge 1 September 30th 05 02:09 PM
Mail merge from Access - Yes/No field converts to True/False J Guerry Mailmerge 2 May 9th 05 04:02 AM


All times are GMT +1. The time now is 07:58 AM.

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

About Us

"It's about Microsoft Word"