Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Leamington Spa, Warwickshire, England
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Mulltiple records per letter office 2007 and comatibility mode

    Hi

    I have a letter to be sent out to landlords about properties they own, Each landlord owns more than one property and I would like the properties listed in 1 letter per landlord.

    For example;

    Landlord
    Landlord Address

    Dear [Landlord]

    You currently are responsible for:

    "Property 1"
    "property 2"

    Please contact me to confirm this is still the case

    I have done a bit of research and know I have to do a directory and use IF and Set fields and insert merge Fields from the Field option rather than the the usual Insert merge fields, also to copy it on page 2.

    However from the links I have seem I can't seem to make much sense of it or get it to work!
    1. the documents / spreadsheet are in compatibility mode - should they be converted?
    2. The way our letters are set out is we have a table for the header of the doc our address in column 2, the addresses in column 1 - will this cause problems - I couldn't drag the } over the border
    3. I get the {If \*MergeFormat on all the codes is this correct?
    4. How can i add some text in the middle of the merge letter

    Any help greatly appreciated

    Michelle

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Michelle,

    You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
    http://lounge.windowssecrets.com/ind...owtopic=731107
    Do read the tutorial before trying to use the mailmerge document included with it.

    As for the \*MergeFormat switches, they're generally of no help at all and serve only to add clutter.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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