Hi,
But when I replace double quote with two double quotes,
word is able to merge.
If Hello!" is what I want to appear in my word letter
after merging then, if I replace Hello!" with Hello!""
word picks up Hello!" by converting two double quotes
into one.
Sample data file
Original data
"Name","Address"
"Guru","Bangalore " Address"
After correction
"Name","Address"
"Guru","Bangalore "" Address"
Now the address coloumn would appear as Bangalore "
Address in my letter.
Kindly advice
Thanks
Guru
-----Original Message-----
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
.