Mail merge - How to change info on same address line? RRS feed

  • Question

  • hi,

    I want to do something like this:

    2/35 Oatland Street

    3/35 Oatland Street

    4/35 Oatland Street

    I don't know how to set my columns so mail merge can recognise and just change the unit number. 

    thanks for the help, and sorry for asking a stupid question.

    Friday, May 5, 2017 8:43 AM

All replies

  • How does your dataset look?
    Are the 2/35 3/35 and 4/35 seperate datarows or should it be generated from something?
    Please provide a example dataset and preview of how you would like it to look.
    Friday, May 5, 2017 1:14 PM
  • Hi,

    I agree with Leo. Could you share a sample file or some screenshots so that we can understand your request more clearly? You can share a sample file or screenshots to us via uploading them to OneDrive.

    Thank you for your understanding.


    Steve Fan

    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Wednesday, May 10, 2017 2:43 AM
  • Unless your unit #s and street #s are in different fields, a mailmerge will be unable to group the records by street #. If they are, it can be done via a directory/catalog merge.

    Paul Edstein
    [MS MVP - Word]

    • Proposed as answer by Steve Fan Thursday, May 11, 2017 3:18 AM
    Wednesday, May 10, 2017 12:00 PM