Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2011
    Posts
    59
    Thanks
    23
    Thanked 2 Times in 2 Posts

    Mail merge all field from excel file into word template

    I have a word template which has been setup to merge with an Excel list.

    In the first field of the Excel list I have name field which is a merged field on the word template «Name»

    In the Excel list right now I have two rows for names, but in the word template you have to proceed to Next Record to show the 2nd name.

    How can I get both names to show up in the word template with having to modify the Excel list to list the 2nd name in a second column or is this the only solution for making both names viewable?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,381
    Thanks
    208
    Thanked 829 Times in 762 Posts
    JRB,

    By definition each row in Excel is considered a Record by Mailmerge. Thus the need to use the NextRecord to get at the second name. So yes you need to move the second name up into the appropriate record in a new column {field}.
    Of course this isn't the only solution but definately the easiest one! The other thing you could do would be to write VBA code then you can do what ever you want but that is much more involved.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    jrb (2012-04-26)

  4. #3
    Star Lounger
    Join Date
    Aug 2011
    Posts
    59
    Thanks
    23
    Thanked 2 Times in 2 Posts
    Thank you RG. That is what I ended up doing, making new columns and is 100% easier than messing with code. Thanks

Posting Permissions

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