Group:  Microsoft Word ยป microsoft.public.word.mailmerge.fields
Thread: Extra space in "Name" field when merged

Geek News

Extra space in "Name" field when merged
Mark 12/30/2008 4:48:13 PM
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
Re: Extra space in "Name" field when merged
"Rich/rerat" <rrr_news[ at ]isp.com> 12/30/2008 5:46:18 PM
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" <Mark[ at ]discussions.microsoft.com> wrote in message
news:683E99BB-05B6-4351-9DC4-C1BA0354CD92[ at ]microsoft.com...
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

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net