Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2007
    Location
    Montreal, Quebec
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If..Then..Else field in mail merge with texte in "quotes"

    Hello gang,

    Still in Office XP.
    Doing a mail merge with an If..Then..Else field where I have to insert text in quotes (i.e. bla bla bla "Cash Portion").
    The insertion of text stops just short of the part in quotes. It ends at bla bla bla. I tried using \"Cash Portion\" but I get \"Cash Portion\" as a result. What can I use to have the " inserted without the \?
    Also, I am using the rounded quotes (ALT-0147 and ALT-0148).
    Help!
    Johanne Champagne
    Montreal (Quebec) CANADA

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Johanne,

    Try using Chr(34)&"Cash Portion"&Chr(34)

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    About the only way you'll get the appearance you're after is with a field coded like:
    {IF{MERGEFIELD MyField}<> "" "\{SYMBOL 147}Some Text{SYMBOL 148} "}
    Note the space after the 2nd SYMBOL field. You can reduce its size to 1pt, but hiding it won't work. Alternatively, you could use pairs of smart single quotes to simulate the smart double quotes:
    {IF{MERGEFIELD MyField}<> "" "‘‘Some Text’’"}

    And, if the quotes are only required for the the mergefield itself, whenever it's not empty, try:
    {MERGEFIELD MyField \b "‘‘" \f "’’"}
    Again, this uses pairs of smart single quotes to simulate the smart double quotes.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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