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 / August 2005

Tip: Looking for answers? Try searching our database.

Form field spacing in a Word/Excel mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Groovykimu - 23 Aug 2005 05:30 GMT
I am trying to set up a mail merge in Word 2000 using data from an Excel 2000
file.

The data is a list of contact names and addresses. I want to do this mail
merge so I can print off address labels for these contacts.

Some of the contacts have titles (Dr, Mr, Ms, etc), however, some do not.
With contacts that have titles, I want the label to have a space between the
title and the first name. With contacts that do not have titles, I want the
names to appear at the start of the first line of the label, without a space.

How can I do this?

I have tried inserting a space after each title in the excel file; however,
Word seems to ignore these spaces.

When I enter the form fields as <<title>>  <<name>>, this creates an ugly
space at the start of the lines for labels where there is no title.

Any advice gratefully received!

Kim
Doug Robbins - 23 Aug 2005 13:04 GMT
Use the following If...then...Else field construction

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

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

Signature

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

>I am trying to set up a mail merge in Word 2000 using data from an Excel
>2000
[quoted text clipped - 23 lines]
>
> Kim

Rate this thread:






 
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.