1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Office XP Mail Merge Spacing

Discussion in 'Microsoft Office' started by windrider, May 8, 2010.

  1. windrider

    windrider Flightless Bird

    I am using Office XP mail merge to send envelops. The merge shows about
    twenty spaces between the first and last name (about one inch or mare apart).
    I am using an Excel spread sheet for the source address names.
    How do I get the first and last name closer together?
     
  2. Bob I

    Bob I Flightless Bird

    One way would be to concatenate the First and Last names in Excel. Or
    perhaps you have spaces after the First name in the Excel file (use
    Find\Replace to remove)

    windrider wrote:

    > I am using Office XP mail merge to send envelops. The merge shows about
    > twenty spaces between the first and last name (about one inch or mare apart).
    > I am using an Excel spread sheet for the source address names.
    > How do I get the first and last name closer together?
     
  3. macropod

    macropod Flightless Bird

    Hi windrider,

    Check what's between the mergefields - you might find a tab or multiple spaces where you want a single space.

    --
    Cheers
    macropod
    [Microsoft MVP - Word]


    "windrider" <windrider@discussions.microsoft.com> wrote in message news:C0037EBA-18BF-4C09-9C9B-AD94EF06B9AD@microsoft.com...
    >I am using Office XP mail merge to send envelops. The merge shows about
    > twenty spaces between the first and last name (about one inch or mare apart).
    > I am using an Excel spread sheet for the source address names.
    > How do I get the first and last name closer together?
     

Share This Page