+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting a mail merge

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    Norwich, UK
    MS-Off Ver
    2010
    Posts
    10

    Conditional formatting a mail merge

    I am currently trying to create a mail merge that uses peoples name in the main body of text i.e.

    Please return Mike Wazowski's name badge to the front desk.

    My problem is that if a name ends with an s grammatically all i need is the apostrophe. Is there a way with conditional formatting (or some other type of Excel wizardry) for Excel or the mail merge to recognise whether the cell value ends in an s?

    Yours,

    An Excel muggle.
    Last edited by pykywannabe; 04-22-2016 at 11:22 AM. Reason: SOLVED

  2. #2
    Registered User
    Join Date
    02-24-2016
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    92

    Re: Conditional formatting a mail merge

    Hi Muggle,

    I asume you have the names in an Excel sheet and loop throu these.
    For each namethe body text is created.

    Please Login or Register  to view this content.
    Hoop this helps,
    WouterM
    The Netherlands

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    Norwich, UK
    MS-Off Ver
    2010
    Posts
    10

    Thumbs up Re: Conditional formatting a mail merge

    Thank you WouterM, that is exactly what I needed! Rep added!

    Solved

+ 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. Replies: 0
    Last Post: 03-04-2016, 06:08 PM
  2. Running Word Mail Merge from Excel 2010 - Mail Merge workbook fails
    By pl05.lau@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2015, 07:35 AM
  3. Formatting cells in mail merge doc
    By lukestkd in forum Word Formatting & General
    Replies: 4
    Last Post: 02-24-2014, 06:36 PM
  4. Formatting for Mail Merge
    By taichi56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2013, 03:34 PM
  5. Replies: 2
    Last Post: 07-12-2012, 08:11 PM
  6. Mail Merge formatting
    By ice in forum Excel General
    Replies: 1
    Last Post: 02-28-2011, 04:31 PM
  7. [SOLVED] Cell formatting in Mail Merge
    By Lighthouse in forum Excel General
    Replies: 3
    Last Post: 12-08-2005, 01:20 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