Results 1 to 3 of 3

Conditional formatting a mail merge

Threaded View

pykywannabe Conditional formatting a mail... 04-22-2016, 09:59 AM
WouterM Re: Conditional formatting a... 04-22-2016, 10:30 AM
pykywannabe Re: Conditional formatting a... 04-22-2016, 11:21 AM
  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

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. 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