View Single Post
  #1  
Old May 4th, 2004, 04:37 AM
Guru
external usenet poster
 
Posts: n/a
Default Double quotes in Mail Merge

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