If..Then..Else field in mail merge with texte in “quotes”

Topic

New Reply

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!

Reply | Quote

Replies

Johanne,

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

HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

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
[Fmr MS MVP - Word]

Reply | Quote