Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Directory Confused!

    Hi All,

    I have seen there is a sticky for mail merges but it is very long and I have a deadline I am trying to reach so I thought I would just give this a go.

    I am trying to create a Directory Mail Merge.

    My data is set-up in Excel as follows with three columns, formatted as a table:

    Account - Title - Price
    JOHN001 - Book1 - £45
    JOHN001 - Book2 - £23
    JOHN001 - Book3 - £19
    MIKE004 - Book1 - £33

    I followed the Microsoft tutorial for the code, using CTRL + F9 etc. EXACTLY as it shows on this link under the first example: http://support.microsoft.com/kb/294686/en-us#2

    This is it:

    { IF { MERGESEQ } = "1" "{ MERGEFIELD Account }
    " "" }{ SET Place1 { MERGEFIELD Account }}
    { If { Place2 } <> { Place1 }"
    { MERGEFIELD Account }

    { MERGEFIELD Title } { MERGEFIELD Price }" "{ MERGEFIELD Title } { MERGEFIELD Price }" }{ SET Place2 { MERGEFIELD Account }}

    I just want to see if it will work, I can personalise the text around the fields later.... but it doesn't work.

    Currently, I am getting a single line, as:

    "Book1 45"

    And that is it...

    Is this because the tutorial is for Office 2010, and I am using 2013? Because I can't imagine any other reason as I have meticulously checked it is an exact replica of what is in the tutorial, 100% certain every {} has been added with Ctrl + F9, and the table is arranged exactly the same way as in the example.

    Please help me out

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    3 Star Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    350
    Thanks
    0
    Thanked 24 Times in 24 Posts
    Is this because the tutorial is for Office 2010, and I am using 2013?
    I don't have a solution for the problem but as to the question, it's quite possible as newer versions can have sometimes minor changes and sometimes major changes. Most changes won't be in the basics but in the more advanced features.

  4. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,855
    Thanks
    0
    Thanked 176 Times in 162 Posts
    Quote Originally Posted by Jake Stokes View Post
    Is this because the tutorial is for Office 2010, and I am using 2013?
    No. The tutorial includes Word 2013 as well. I don't know why you'd think it's for Office 2010 - it currently spans all Office versions from 97 to 2013, though the 'Applies to' lists only:
    • Microsoft Word 2013
    • Microsoft Word 2010
    • Microsoft Office Word 2007
    • Microsoft Word 2002

    My tutorial (http://windowssecrets.com/forums/sho...merge-Tutorial) likewise spans all Office versions from 97 to 2013.

    Your problem description suggests you're just previewing the merge instead of finishing it. As my tutorial says, Previews are not reliable indicators of the merged output.
    Last edited by macropod; 2014-08-01 at 19:04.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Tags for this Thread

Posting Permissions

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