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 / April 2007

Tip: Looking for answers? Try searching our database.

mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Candice - 04 Apr 2007 16:48 GMT
I tried to complete a mail merge from an excel spreadsheet to a Word 2003
envelope.  Each entry has a space before the first letter of the first word.  
I can't seem to remove it with out going through each individual envelope
after completing the merge and deleting it.
Peter Jamieson - 04 Apr 2007 17:51 GMT
Are you using ADDRESSBLOCK?

If so, then for example, if you chose the Mr. Josh Q. Randall Jr. layout and
the title (Mr.) and "Nickname" (Josh) are either blank or not matched, the
layout will stil insert a space before the "Q.". IN essence, the layout
expects there to be either a title or a nickname. Incidentally, if there is
a title, no nickname, and a "middle name" you will get Mr.  Q. Randall Jr.
(i.e. two spaces before the Q).

You can either try reinserting your ADDRESSBLOCK with a different layout
that matches your data better, or use individual merge fields instead - see
Graham Mayor's pages at
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
and
http://www.gmayor.com/formatting_word_fields.htm

Peter Jamieson
>I tried to complete a mail merge from an excel spreadsheet to a Word 2003
> envelope.  Each entry has a space before the first letter of the first
> word.
> I can't seem to remove it with out going through each individual envelope
> after completing the merge and deleting it.
Candice - 04 Apr 2007 18:22 GMT
THANK YOU!!  That solved the problem.  My supervisor says to tell you we love
you haha!  But thanks again for describing the reasoning behind it not just
telling me what to do.  We understand why it was adding the space now.

> Are you using ADDRESSBLOCK?
>
[quoted text clipped - 18 lines]
> > I can't seem to remove it with out going through each individual envelope
> > after completing the merge and deleting it.
 
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.