+ Reply to Thread
Results 1 to 3 of 3

Mail Merge - Print alternative cell value if first empty

  1. #1
    Registered User
    Join Date
    10-24-2017
    Location
    London
    MS-Off Ver
    2007, 2016 and 2019 Professional
    Posts
    11

    Post Mail Merge - Print alternative cell value if first empty

    Hi all,

    I have a spreadsheet with two columns of names.
    The first column has the primary person's names and the second column holds the reserve person's names.

    This is set up so that if there is no primary person the reserve will step in.

    Using Microsoft Word I want to mail merge letters to each of the primary people. However, if there is no named primary person then I want the reserve person's name to be printed instead. Is this possible?

    Hopefully that is clear enough. Any help, pointers, etc would be gratefully received.

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Mail Merge - Print alternative cell value if first empty

    Probably easier to just fix the spreadsheet. I would think if a primary is blank, then the reserve is really the primary, so in that case, just put the secondary in as the primary. If you still want unfilled primaries, then create a third column that you will use in your mail merge. The equation in the column would be something like: =if(isblank(A1),A2,A1)
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    10-24-2017
    Location
    London
    MS-Off Ver
    2007, 2016 and 2019 Professional
    Posts
    11

    Re: Mail Merge - Print alternative cell value if first empty

    I knew that! But forgot to use commonsense, not a first. I can do this but since I need to copy and paste in the most up-to-date information was trying to use mail merge instead. But if I place the third column at the far right side then I can still do the update and the mail merge.

    Thanks for the help and here's a teacher's star for you. ;-)

+ 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] Documents created from mail merge won't print
    By mgs73 in forum Word Formatting & General
    Replies: 7
    Last Post: 02-28-2016, 08:05 PM
  2. [SOLVED] vba to print mail merge results
    By excelloser in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 10:49 AM
  3. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  4. Print mail merge document
    By LisaPatch in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 10-31-2011, 09:54 AM
  5. IF Statement in Word Mail Merge Adding Extraneous Empty Page
    By nycstinger in forum Word Formatting & General
    Replies: 0
    Last Post: 09-11-2009, 11:14 AM
  6. [SOLVED] nine digit zip code won't print in mail merge
    By Durham in forum Excel General
    Replies: 8
    Last Post: 10-24-2005, 11:05 AM
  7. Envelopes will not print using mail merge.
    By mission in forum Excel General
    Replies: 1
    Last Post: 09-29-2005, 06:05 AM

Tags for this Thread

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