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 2007

Tip: Looking for answers? Try searching our database.

mail merge greeting-why are spaces added

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
fustrated165 - 24 Aug 2007 02:06 GMT
when I do a mail merge spaces are sometimes added.
ie  Mr. Jones  Mr.  Adams  one space sometimes and sometimes 2 spaces are
added instead.
When I manually try to remove it, when I print it, it reverts to two spaces
Any ideas?
Graham Mayor - 24 Aug 2007 07:34 GMT
Assuming the space is not in your data source, then we need more information
about what you are doing - Word version, data source, what fields you have
inserted and how they are laid out etc.,

Signature

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

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

> when I do a mail merge spaces are sometimes added.
> ie  Mr. Jones  Mr.  Adams  one space sometimes and sometimes 2 spaces
> are added instead.
> When I manually try to remove it, when I print it, it reverts to two
> spaces Any ideas?
oe - 29 Aug 2007 16:41 GMT
Does your data source have FirstName (or Initial) as a field which is blank
for some people?

> when I do a mail merge spaces are sometimes added.
> ie  Mr. Jones  Mr.  Adams  one space sometimes and sometimes 2 spaces are
> added instead.
> When I manually try to remove it, when I print it, it reverts to two
> spaces
> Any ideas?
Peter Jamieson - 29 Aug 2007 16:56 GMT
If you are using the GREETINGLINE field, it may be because you have chosen
the layout that inserts "Mr. Joshua Randall Jr."

In that case, if there is a firstname field, you will get
courtesytitle<space>firstname<space>lastname
but if there is no firstname, you will get
courtesytitle<space><space>lastname

- if you use ctrl-F9 to examine the contents of the GREETINGLINE field, it
is fairly clear to me why this is so.

I wouldn't try to work around this by editing the GREETINGLINE field - it's
probably better - though not particularly easy - to insert individual fields
with the logic necessary to insert the spaces you need.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> when I do a mail merge spaces are sometimes added.
> ie  Mr. Jones  Mr.  Adams  one space sometimes and sometimes 2 spaces are
> added instead.
> When I manually try to remove it, when I print it, it reverts to two
> spaces
> Any ideas?

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.