Share via

mail merge

Anonymous
2023-12-27T17:12:03+00:00

I am having trouble with Mail Merge. When I go to "select merge field" it automatically goes to the next line instead of going in the same line like for city, state zip. It goes in as:

city,

state

zip

I'm sure there is a setting for line spacing or margin or something that is not correct.

I contacted Microsoft support and the lady said something that Microsoft Word was running under Microsoft 365 for Business and not Microsoft Home & business 2019 which is the old program that I have. The Microsoft 365 for Business was installed by the company I work for as an independent contractor that I log into.

Should I be uninstalling the original Microsoft Home & Business 2019, could that be the issue? I wouldn't think so. I think it is margin, line spacing, etc issue.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

9 answers

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
    2023-12-29T22:39:05+00:00

    Check the formatting of the Normal style in the Normal.dotm template. The formatting of that style will be used for the text on labels.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Charles Kenyon 167.4K Reputation points Volunteer Moderator
    2023-12-28T03:23:37+00:00

    I suspect you are using the wrong label template.

    Turn on display of non-printing formatting marks and then, under the Table Layout tab, check the box for gridlines.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
    2023-12-27T22:31:11+00:00

    There are two way that the Insert Merge Field facility can be used.

    One is by clicking on the dropdown arrow to the right of the word Field

    The other in by clicking on the Icon above Insert Merge

    With the second method, pressing enter when a field is selected performs the same action and clicking on the Insert command button, but it does not de-select the field so that pressing enter again will insert another instance of the field.

    Which ever method you use, you need to make sure that the Insertion Point (Selection) is in the correct place in the mail merge main document when you insert each field.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Charles Kenyon 167.4K Reputation points Volunteer Moderator
    2023-12-27T17:55:51+00:00

    You can edit the primary merge document to remove those.

    Resources:

    Uninstalling and reinstalling is unlikely to help.

    There are a number of ways of inserting merge fields, Can you give, step-by-step, the process you are using?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2023-12-27T19:38:32+00:00

    I open a blank word document

    Go to the Mailings tab

    Click Start a Mail Merge and select labels

    Find the label option I want and click OK

    Click on Select Recipients then go down to Select Use an Existing List

    Find the excel spreadsheet I want to use and click Open

    Click OK in the Select Table box that opens up

    Then the document opens up for me to select the merge fields

    Go back to the Mailings Tab and select Insert Merge Fields

    the drop down shows the fields I want to select

    I select Name and hit Enter but it doesn't drop down to the next line so I can enter the address on the next line.

    But when I select the next field, Address 1, it does enter it below Name. Then I hit Space and nothing happens.

    So I select the next field Address 2 and it puts it on the next line instead of next to Address 1.

    So I select the next field City, and it puts it on the next line which is fine but then I click Space and nothing happens.

    So I select the next field State and it puts it on the next line instead of next to City, etc

    And when I check it and do Update Labels and Finish & Merge it's like the label information is very narrow and it will only show for example each row/column as:

    Jim

    Smith50

    450

    87th

    Ave

    San Die

    And that's it. So it has to be the spacing, indentation, layout or something I'm guessing.

    When I start the document I check the Margins and make sure it is on Normal.

    I check the Indentation and Spacing and it is on 1" left, 1" right

    Spacing Before: 0pt

    Spacing After: 8pt

    But when I start the Mail Merge the Layout Settings are:

    Margins: Custom Margins

    1" left: 1" right

    Spacing Before: 5.6pt

    Spacing After: 8pt

    I don't know if that's correct or not and why the mail merge columns with the information set up so awkwardly.

    I'm not sure if I explained it all that well or not. I have never in 20 years had such problems.

    Was this answer helpful?

    0 comments No comments