+ Reply to Thread
Results 1 to 2 of 2

In Merge Directory how to repeat block of info for all merge entries

  1. #1
    Registered User
    Join Date
    04-30-2010
    Location
    Pebble Beach, California
    MS-Off Ver
    2016
    Posts
    44

    In Merge Directory how to repeat block of info for all merge entries

    Thank you in advance for the help.

    I am trying to create a membership directory from a .csv file. I can get the first set of data set up properly, but I do not know how to repeat it for subsequent members.

    «Last_Name», «Title» «First_Name» «Middle_Initial» («Spouse_Name» "«Spouse_Nickname»")
    «Address_Line_1», «City», «State» «Zip» «Home_Phone»
    Mobile («First_Name») «Cell_Phone»
    Email («First_Name») «Primary_Email»
    Mobile («Spouse_Name») «Cell_Phone1»
    Email («Spouse_Name») «Primary_Email1»

    Additionally, I only want the Spouse_Nickname to show up in quotes if it is present in the .csv file)

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,646

    Re: In Merge Directory how to repeat block of info for all merge entries

    Have you tried finishing the merge?

    As for the Spouse_Nickname, encode the mergefield as:
    {MERGEFIELD Spouse_Nickname \b "“" \f "”"}
    Selecting the field and pressing Shift-F9 will expose the field code.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Directory Mail Merge
    By Carrol in forum Word Formatting & General
    Replies: 5
    Last Post: 04-20-2020, 06:51 PM
  2. How to block Merge Function?
    By superlative in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2020, 06:08 PM
  3. Mail Merge Directory - Creating merge with multiple lines
    By tiggynook in forum Excel General
    Replies: 3
    Last Post: 05-03-2017, 03:00 PM
  4. Merge cell contents into a text block?
    By satori in forum Excel General
    Replies: 3
    Last Post: 10-31-2008, 07:32 PM
  5. [SOLVED] ***PLease help. Need to Merge directory of files into one file.***
    By Shani in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-04-2006, 11:55 AM
  6. Mail Merge directory v2003
    By leaftye - ExcelForums.com in forum Excel General
    Replies: 2
    Last Post: 06-16-2005, 12:05 PM
  7. [SOLVED] Merge all files in directory
    By TEB2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 08:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1