View Single Post
  #2  
Old May 4th, 2004, 08:48 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default Double quotes in Mail Merge

Not easily

The method which works is to open the data source document in Word

Use the replace function to perform a wildcard search for
"([!"])
replace with
\1

This will remove the field separation quotes, leaving the single quotes (it
will leave a final quote at the end of the document which must be removed by
hand if not required there).

Select the text and from the table menu, convert text to table.

Save the document and use it as a datasource for your merge.

--

Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word




Guru wrote:
Hi,

How can I handle double quotes in Mail Merge?
I have datasource file which is like this

"Col1","Col2","Col3"
"abc","23"","xyz"

The above data fails to merge because the second value in
the second row i.e 23" has a double quote. How can I
handle this problem. I have replaced the double quote with
two double quotes and it worked for me. Is this the right
approach or is their a better way to solve this.

Also, will replacing the double quote with 2 double quotes
result in any mismatch between the columns.

Kindly advice.

Thanks
Guru