|
|
IF/THEN/ELSE adds a blank line in mail merge WORD 2007
Hello,
I need to merge some mailings based on if the first name is not the
same as nickname, print nickname else don't print anything and go to
the next field. The code I have is:
{IF {MERGEFIELD fName} <> {MERGEFIELD nName} {MERGEFIELD nName} ""}
What is happening is if the first name and nickname are the same a
blank line appears. How do I supress the blank line?
|
|
0
|
|
|
|
Reply
|
 gabo
|
11/13/2009 9:15:32 PM |
|
Make the line break part of your TrueText (note that you don't have to
include FalseText if it's "nothing"). So you'll have:
{I F { MERGEFIELD fName } <> { MERGEFIELD nName } "{ MERGEFIELD nName }
" }
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"gabo" <gabo22003@yahoo.com> wrote in message
news:3d07e4d8-e736-4226-9f9d-6f7b32b8a31a@o13g2000vbl.googlegroups.com...
> Hello,
>
> I need to merge some mailings based on if the first name is not the
> same as nickname, print nickname else don't print anything and go to
> the next field. The code I have is:
>
> {IF {MERGEFIELD fName} <> {MERGEFIELD nName} {MERGEFIELD nName} ""}
>
>
> What is happening is if the first name and nickname are the same a
> blank line appears. How do I supress the blank line?
>
|
|
|
0
|
|
|
|
Reply
|
Suzanne
|
11/13/2009 9:27:38 PM
|
|
On Nov 13, 4:27=A0pm, "Suzanne S. Barnhill" <sbarnh...@mvps.org> wrote:
> Make the line break part of your TrueText (note that you don't have to
> include FalseText if it's "nothing"). So you'll have:
>
> {I F { MERGEFIELD fName } <> { MERGEFIELD nName } "{ MERGEFIELD nName }
> " }
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USAhttp://word.mvps.org
>
> "gabo" <gabo22...@yahoo.com> wrote in message
>
> news:3d07e4d8-e736-4226-9f9d-6f7b32b8a31a@o13g2000vbl.googlegroups.com...
>
>
>
> > Hello,
>
> > I need to merge some mailings based on if the first name is not the
> > same as nickname, print nickname else don't print anything and go to
> > the next field. The code I have is:
>
> > {IF {MERGEFIELD fName} <> {MERGEFIELD nName} {MERGEFIELD nName} ""}
>
> > What is happening is if the first name and nickname are the same a
> > blank line appears. How do I supress the blank line?- Hide quoted text =
-
>
> - Show quoted text -
Thank you,
I have for the code:
{ IF{ MERGEFIELD fName } <> {MERGEFIELD nName } "{MERGEFIELD nName }
"}
and this stil shows a blank line. for the quotes I've used double/
single and it is still inserting a blank line
|
|
|
0
|
|
|
|
Reply
|
gabo
|
11/13/2009 9:57:59 PM
|
|
If you want the firstname on one line and the nickname if it is not the same
as the firstname on the next line, use the following field construction
{ MERGEFIELD fName }{ IF { MERGEFIELD fName } = { MERGEFIELD nName } "" "�
{ MERGEFIELD nName }" }
Where you press the Enter key (or Shift+Enter) where the � appears.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"gabo" <gabo22003@yahoo.com> wrote in message
news:3d07e4d8-e736-4226-9f9d-6f7b32b8a31a@o13g2000vbl.googlegroups.com...
> Hello,
>
> I need to merge some mailings based on if the first name is not the
> same as nickname, print nickname else don't print anything and go to
> the next field. The code I have is:
>
> {IF {MERGEFIELD fName} <> {MERGEFIELD nName} {MERGEFIELD nName} ""}
>
>
> What is happening is if the first name and nickname are the same a
> blank line appears. How do I supress the blank line?
|
|
|
0
|
|
|
|
Reply
|
Doug
|
11/13/2009 10:20:37 PM
|
|
Did you remove the line break you had *after* the mergefield? Note that the
mergefield for your next line should immediately follow this one:
{ IF{ MERGEFIELD fName } <> {MERGEFIELD nName } "{MERGEFIELD nName }
"}{ MERGEFIELD whatever }
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"gabo" <gabo22003@yahoo.com> wrote in message
news:621945b5-b6b0-4de7-9301-05ea8bd191a9@m20g2000vbp.googlegroups.com...
On Nov 13, 4:27 pm, "Suzanne S. Barnhill" <sbarnh...@mvps.org> wrote:
> Make the line break part of your TrueText (note that you don't have to
> include FalseText if it's "nothing"). So you'll have:
>
> {I F { MERGEFIELD fName } <> { MERGEFIELD nName } "{ MERGEFIELD nName }
> " }
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USAhttp://word.mvps.org
>
> "gabo" <gabo22...@yahoo.com> wrote in message
>
> news:3d07e4d8-e736-4226-9f9d-6f7b32b8a31a@o13g2000vbl.googlegroups.com...
>
>
>
> > Hello,
>
> > I need to merge some mailings based on if the first name is not the
> > same as nickname, print nickname else don't print anything and go to
> > the next field. The code I have is:
>
> > {IF {MERGEFIELD fName} <> {MERGEFIELD nName} {MERGEFIELD nName} ""}
>
> > What is happening is if the first name and nickname are the same a
> > blank line appears. How do I supress the blank line?- Hide quoted text -
>
> - Show quoted text -
Thank you,
I have for the code:
{ IF{ MERGEFIELD fName } <> {MERGEFIELD nName } "{MERGEFIELD nName }
"}
and this stil shows a blank line. for the quotes I've used double/
single and it is still inserting a blank line
|
|
|
0
|
|
|
|
Reply
|
Suzanne
|
11/13/2009 11:25:39 PM
|
|
|
4 Replies
1404 Views
(page loaded in 0.072 seconds)
Similiar Articles: IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ...Hello, I need to merge some mailings based on if the first name is not the same as nickname, print nickname else don't print anything and go to t... Eliminate blank fields in mail merge from Excel to Word ...IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... Eliminate blank fields in mail merge from Excel to Word ... IF/THEN/ELSE adds a blank line in mail ... Blank page prints in between mail merged document - microsoft ...IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... Blank page prints in between mail merged document - microsoft ... IF/THEN/ELSE adds a blank line in ... Label - Mail Merge - Word 2007 - microsoft.public.word ...Label - Mail Merge - Word 2007 - microsoft.public.word ... question about formatting labels (mail merge) - microsoft.public ... IF/THEN/ELSE adds a blank line in mail ... How to add a blank line in a combobox - microsoft.public.access ...IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... If..Then..Else statement not working for Ye/No ComboBox ..... to add a blank line in a combobox ... Super Easy Word Merge (Access module) - microsoft.public.access ...Removing Empty Line - microsoft.public.access.reports Try open a new, blank module and paste this function ... IF/THEN/ELSE adds a blank line in mail merge WORD 2007 ... insert a blank line - microsoft.public.access.reportsIF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... Hello, I need to merge some mailings based on if the first name is not the same as nickname, print ... Publisher 2003 Mail merge from Excel causing extra spaces- PLEASE ...IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... Publisher 2003 Mail merge from Excel causing extra spaces- PLEASE ... IF/THEN/ELSE adds a blank line ... the blank page in Word 2007 contains text - microsoft.public.word ...IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... How do I supress the blank line?- Hide quoted text - > > - Show quoted text ... Combine lines in a Report? - microsoft.public.access.reports ...IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ... Report as ... IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - Microsoft ...New Users ... Hello, I need to merge some mailings based on if the first name is not the same as ... Make the line break part of your TrueText (note that you don't ... IF/THEN/ELSE adds a blank line in mail merge WORD 2007 - microsoft ...Hello, I need to merge some mailings based on if the first name is not the same as nickname, print nickname else don't print anything and go to t... IF/THEN/ELSE adds a blank line in mail merge WORD 2007Posted: Fri Nov 13, 2009 1:15 pm Post subject: IF/THEN/ELSE adds a blank line in mail merge WORD 2007 Archived from groups: microsoft>public>word>newusers ... WD97: How to Suppress Blank Lines During a Mail MergeDuring a mail merge in Microsoft Word, you may want to remove blank lines from ... is anything else on that line ... box, and then click Close in the Mail Merge Helper. IF/THEN/ELSE adds a blank line in mail merge WORD 2007Hello, I need to merge some mailings based on if the first name is not the same as nickname, print nickname else don't print anything and go to the 7/19/2012 12:19:41 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
30 followers. 