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  

Blank merge fields



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2005, 02:16 PM
ASBiss
external usenet poster
 
Posts: n/a
Default Blank merge fields

I can see from previous postings that it is possible to supress a field if
it's blank.

However, from the answers given I can't quite work out how to insert the If
then else field. ie

Title Name Surname

In some cases I don't have a title and want to omit the space before if
there isn't one so just Name and Surname appear on the letter

Could someone explain this to me in layman's terms!?
  #2  
Old May 25th, 2005, 05:18 PM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

The simplest way to insert IF fields is, in my view, to avoid Word's field
insertion dialog boxes and do it more directly. The main keystrokes you need
are
a. Ctrl-F9, which inserts a pair of the special "field braces" {} that
surround each field. Everything between those special {} can be plain text
that you type in the usual way.
b. Alt-F9, which lets you toggle between "field code view", where fields
look like { MERGEFIELD myfield }, and "field preview/results" view, where
mergefields show as myfield or their results
c. select a field and press F9 to update its result.

In this case, one way you can do it is

{ IF { MERGEFIELD Title } = "" "" "{ MERGEFIELD Title } "
}{ MERGEFIELD Name } { MERGEFIELD Surname }

although I would probably use

{ IF "{ MERGEFIELD Title }" = "" "" "{ MERGEFIELD Title } "
}{ MERGEFIELD Name } { MERGEFIELD Surname }

simply to play safe.

For the IF field you can do the following

1. ctrl-F9:
{ }
2. Put the insertion point after the opening brace and the first space, and
type everything outside the fields:
{ IF "" = "" "" " " }
NB, you must have a space either side of the = sign.
3. Then put the insertion point inside the first "" and use crtl-F9 again:
{ IF "{ }" = "" "" " " }
4. Put the insertion point inside the new { } and type MERGEFIELD Title:
{ IF "{ MERGEFIELD Title }" = "" "" " " }
5. repeat (3) and (4) to insert the second MERGEFIELD field:
{ IF "{ MERGEFIELD Title }" = "" "" "{ MERGEFIELD Title } " }

As an alternative to (3),(4),(5), you can put the insertion point where you
want the field to go and use the appropriate button on the merge toolbar to
insert the MERGEFIELD fields. You may find that you need to use Alt-F9 to
get back to the field code view to insert the next merge field.

If that isn't what you needed to know, let us know where you're getting
stuck.

Peter Jamieson

"ASBiss" wrote in message
...
I can see from previous postings that it is possible to supress a field if
it's blank.

However, from the answers given I can't quite work out how to insert the
If
then else field. ie

Title Name Surname

In some cases I don't have a title and want to omit the space before if
there isn't one so just Name and Surname appear on the letter

Could someone explain this to me in layman's terms!?



 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Which fields can be used for merge, and can you add to this Sue Mosher [MVP-Outlook] Contacts 1 February 18th, 2005 05:51 PM
Prevent Blank Records being written. Need Help. Robert Nusz @ DPS Using Forms 4 December 29th, 2004 05:15 PM
Merge Fields and Formating - How to easily repeat a pre-set merge. David Nelson Mailmerge 7 December 27th, 2004 09:55 PM
Word 2002 Mail Merge - merging to new doc displays blank empty dia Steve Vincent Mailmerge 1 December 15th, 2004 06:28 PM
Optional Merge Fields Pete Bennett Mailmerge 4 August 25th, 2004 11:03 AM


All times are GMT +1. The time now is 05:16 AM.


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