Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

automatically inserting text in a merge field blank field.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DrTominRI - 15 Dec 2005 14:51 GMT
I greatly appreciate the help this neophyte recieved here recently so here is
another question.

I am using an access DB to create a merged word Document, sending letters to
other colleagues.  I have it set up fine if I know the recipeints last name
and company, but if the name field is blank I would like it to automatically
insert another word.  e.g if it is to Mr smith, at Mountainview Business Ctr
it should say "Dear Mr Smith".  But if it is to some one unknown at Bayview
Business Ctr it should say "Dear Colleague"

I have the Insert before or after if not blank thing down, but the preformed
wizard that comes up with the genereic <<greeting line>> is not what I want

Thanks
Tom
Cindy M  -WordMVP- - 19 Dec 2005 21:18 GMT
Hi =?Utf-8?B?RHJUb21pblJJ?=,

> I am using an access DB to create a merged word Document, sending letters to
> other colleagues.  I have it set up fine if I know the recipeints last name
[quoted text clipped - 5 lines]
> I have the Insert before or after if not blank thing down, but the preformed
> wizard that comes up with the genereic <<greeting line>> is not what I want

Is this alternate form of address something you have stored in a look-up table,
and can bring into the data source via a query? If yes, then you can set up an
IF field in the mail merge that looks something like

Dear { IF { Mergefield Name } = "" "{ Mergefield AltAddress }" "{ Mergefield
Name }" }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Graham Mayor - 20 Dec 2005 06:35 GMT
Or if the alternative is not in the data file you could test the missing
field as suggested by Cindy and insert the following construction:

Dear {IF{Mergefield name} <> "" "{Mergefield Name}" "Colleague" }

Use CTRL+F9 to insert the field boundaries {}

You may find http://www.gmayor.com/formatting_word_fields.htm useful.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Cindy M -WordMVP- wrote:

> Hi =?Utf-8?B?RHJUb21pblJJ?=,
>
[quoted text clipped - 25 lines]
> This reply is posted in the Newsgroup; please post any follow
> question or reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.