Thanks for that Peter.
I tried looking for Mail Merge rules that prohibited a single quotation mark
but found no warnings. It seems a little odd to me, given that an Excel cell
is allowed to contain text, and that mail merge has no problem with a pair of
quotation marks in a cell.
Do you know if this 'rule' (and any others) is written explicitly within
Word Help or Microsoft Help?
Alan Olrog
"Peter Jamieson" wrote:
Is this behaviour expected? I'm linking with DDE.
Unfortunately, yes. If you aren't trying to produce a fully automated merge
for use by someone else, your best bet is probably to replace the " by two
single quotes '' throughout the Excel sheet before you merge.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Alan Olrog" Alan wrote in message
...
I thought I'd successfully merged an Excel spreadsheet into a Word
document.
However, a few cells contain text with quotation marks (") and I see that
where there is a pair there's no problem. Where there is just one (e.g.
19")
it gets confused and concatenates all the following fields up to the end
of
the row. Is this behaviour expected? I'm linking with DDE. Any help
appreciated!