Need to eliminate double spaced address field in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Millerick - 06 Oct 2006 15:33 GMT

When performing a mail merge in Word, there are spaces between the lines in
the address fields (which comes from an XL spreadsheet data source).

I need to eliminate the spaces between the lines, of course.

Thanks,
Chris
cmillerick@elliotwhittier.com
617-846-5000 X 135

Reply to this Message

Graham Mayor - 06 Oct 2006 15:39 GMT

Format the address with a style that doesn't have inter-paragraph spacing.

Signature

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

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

> When performing a mail merge in Word, there are spaces between the
> lines in the address fields (which comes from an XL spreadsheet data
[quoted text clipped - 6 lines]
> cmillerick@elliotwhittier.com
> 617-846-5000 X 135

Reply to this Message

Chris Millerick - 06 Oct 2006 16:28 GMT

Thank you. How do I do that?

> Format the address with a style that doesn't have inter-paragraph spacing.
>
[quoted text clipped - 8 lines]
> > cmillerick@elliotwhittier.com
> > 617-846-5000 X 135

Reply to this Message

Doug Robbins - Word MVP - 06 Oct 2006 19:18 GMT

Select everything in the mailmerge main documnet and then from the Format
menu, select Paragraph and set the Space Before and the Space After the
paragraphs to 0 and set the Line Spacing to Single.

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

> Thank you. How do I do that?
>
[quoted text clipped - 11 lines]
>> > cmillerick@elliotwhittier.com
>> > 617-846-5000 X 135

Reply to this Message

Chris Millerick - 10 Oct 2006 13:44 GMT

I found that if instead of using the address block, if i Merged one field in
at a time it came out without the double spaces. (By using SHIFT>Enter after
each field insted of just enter, which would result in a double space. I
figured this out before your response. I will try your solution next time!
Thank you very much

> Select everything in the mailmerge main documnet and then from the Format
> menu, select Paragraph and set the Space Before and the Space After the
[quoted text clipped - 15 lines]
> >> > cmillerick@elliotwhittier.com
> >> > 617-846-5000 X 135

Reply to this Message