#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Windy Windy is offline
external usenet poster
 
Posts: 1
Default merge

In my letter I have Dear ...
I want to insert field for "nickname" if not blank otherwise "first name".
How
do I do this? My data source has 2 separate columns. Do I need to merge
them first?

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default merge

{ IF { MERGEFIELD NickName } "" { MERGEFIELD NickName } { MERGEFIELD
FirstName } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and you use
Alt+F9 to toggle off their display.

--
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

"Windy" wrote in message
news
In my letter I have Dear ...
I want to insert field for "nickname" if not blank otherwise "first name".
How
do I do this? My data source has 2 separate columns. Do I need to merge
them first?



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
Word 2003 pulls up my mail merge template, but doesn't complete the merge into a new Form Letter 1 Sean Steele Mailmerge 1 April 12th 07 11:04 PM
How to merge Excel chart for mass Word Mail Merge for employees hmboomer Mailmerge 3 June 9th 06 10:08 PM
Printing a mail merge doc, merge fields print with grey background Stanby Microsoft Word Help 1 April 12th 06 03:21 PM
Insert Merge Field problem with Word-Mail Merge from Excel documen Augusta E. Microsoft Word Help 2 June 20th 05 10:59 AM
Mail Merge: How do you merge to file but create separate files david Mailmerge 1 March 22nd 05 07:11 AM


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