Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark Mark is offline
external usenet poster
 
Posts: 182
Default Extra space in "Name" field when merged

When I merge data into the 'name' field, the first line of the address block,
there is an extra space in front of the name. The merge is coming from Excel
and i have checked the formatting for the cells and it all appears
fine..Thanks in advance
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 93
Default Extra space in "Name" field when merged

Mark,
It's recommended that you do not use the Address Block feature when using Mail
Merge. I prefer to insert each field separately, and set the spacing and
line/paragraph format.

The Address Block may be including a "Title" field, so when a record does not
have a "title", it leaves a space. If you insert the fields separately, if a
field does not have a value, the next field shifts to the left or up, and fills
in the space, where the first field would have occupied.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"Mark" wrote in message
...
When I merge data into the 'name' field, the first line of the address block,
there is an extra space in front of the name. The merge is coming from Excel
and i have checked the formatting for the cells and it all appears
fine..Thanks in advance

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Marking records as "merged" (or "printed") Itsaplane Mailmerge 1 September 19th 07 08:35 PM
how do I set up a "expand/collapse" or "show/hide" field in Word WordDoc_FeatureUser Microsoft Word Help 2 May 12th 07 06:29 PM
"Print current page" should have a "+n pages" field. rawahoho Microsoft Word Help 5 November 16th 06 04:26 PM
to make double space inbetween the sentences seperated by"."or"?" dinesh New Users 1 August 26th 06 09:58 PM
"...merged field does not exist..." Driving me nuts! MichaelHunter Mailmerge 3 November 10th 05 07:49 PM


All times are GMT +1. The time now is 01:31 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"