+ Reply to Thread
Results 1 to 2 of 2

Mail Merge if then

  1. #1
    Forum Contributor
    Join Date
    11-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 365
    Posts
    287

    Mail Merge if then

    I want to add an ampersand between names if ?SH2_FIRST_NAME? is not blank.

    Please Login or Register  to view this content.
    I can't seem to make it work.

    Thanks

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

    Re: Mail Merge if then

    Open your document, press Alt-f9 to expose the field codes, then edit them and the content so that you get:

    Dear {MERGEFIELD SH1_FIRST_NAME}{MERGEFIELD SH2_FIRST_NAME \b " &"}

    Press Alt-f9 again when you're done, then run the mailmerge.
    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. Mail Merge - Create separate Mail merge pdf for each sheets of an excel file
    By sureshbvs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2021, 12:38 PM
  2. Replies: 5
    Last Post: 11-15-2018, 10:54 PM
  3. Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  4. Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  5. Replies: 2
    Last Post: 01-22-2013, 11:37 AM
  6. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  7. Replies: 0
    Last Post: 04-21-2006, 03:40 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