Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Escaping quotes in .csv mail merge data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GDR - 11 Aug 2004 22:14 GMT
When doing mail merge from a .csv data file,  the mail
merge blows up when there are double quotes (") in any of
the data fields.  Is there any way to escape these extra
quotes?

TIA,

GDR
Peter Jamieson - 12 Aug 2004 14:46 GMT
Can't remember off the top of my head what works with .csv, but I am
reasonably sure that the only think that /might/ work is to double up each
double quote in the data, i.e. replace

,"abc","d"ef","ghi"

by

,"abc","d""ef","ghi"

Even if that works, you may find that things are slightly different in the
case where the quote is at the beginning of the field, e.g. I'm not sure
changing

,""jkl",

to

,"""jkl",

works. If not, you could try

," ""jkl",

Signature

Peter Jamieson

> When doing mail merge from a .csv data file,  the mail
> merge blows up when there are double quotes (") in any of
[quoted text clipped - 4 lines]
>
> GDR

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.