Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mail merge alignment (2003)

    Hi all, I have created a mail merge but the recipients address appear as one line
    e.g 266 Holby street, Kingston, London, KT1 PT and not
    266
    Holby street,
    Kingston, London
    KT1 PT

    The address data is in excel format. Does anyone know how to fix this problem?

    Cheers

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mail merge alignment (2003)

    Are the house number, street name, city and postal code separate columns in the Excel data source or do you have a single column for the address?

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge alignment (2003)

    The address is in one single column and in one row.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mail merge alignment (2003)

    How then would you expect Word to distribute the address over several lines?

    You should restructure the Excel worksheet so that each item (house number, for example) is in a separate column; each column will be available as a merge field in Word.

  5. #5
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge alignment (2003)

    Well, I have a spreadsheet, please have a look how the address is displayed, click on one of the addresses and have a look, I would like to end up with the same result.

    Cheers.
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mail merge alignment (2003)

    Ok the addresses contain line breaks. The screenshot below shows what I get when I use the worksheet as data source for mail merge (after inserting suitable column headings).
    Attached Images Attached Images
    • File Type: png x.png (2.5 KB, 0 views)

  7. #7
    Star Lounger
    Join Date
    Jun 2005
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mail merge alignment (2003)

    So I have to enter suitable column headings for each line of the address.

    Thanks

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: mail merge alignment (2003)

    The first row of the spreadsheet should contain column headings (field names).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •