View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Andrew Andrew is offline
external usenet poster
 
Posts: 48
Default Merging a data extract to Word 2002

Hi,

I have extracted data from my progress database to a text file and want to
merge the data into word. Some of the database fields contain free text,
therefore users have naturally enough used characters such as quotation
marks, commas and carriage returns in these fields. I thought I could get
round this by using | as the field delimiter and ~ as the record delimiter
and, indeed this worked ok, producing fields with the offending characters
read faithfully as text. But now when I try to add more fields using the
same conventions and with characters such as ",CR when I attach the data
source in Word the dialog box where you specify the field and record
delimiters fails to display and the data merges as one glutinous lump!
Am I missing an obvious solution here? Myself and a colleague have checked
and can see no difference between the fields where the offending characters
work and the ones where they don't.
HELP!!!