Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with one quotation mark.
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! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with one quotation mark.
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! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with one quotation mark.
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! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Problem with one quotation mark.
Do you know if this 'rule' (and any others) is written explicitly within
Word Help or Microsoft Help? Not as far as I know. You are more likely to find a knowledgebase article about it (http://support.microsoft.com) although I think in this case the articles that do exist describe slightly different problems. It is unfortunate of course that in DDE is "obsoleescent" (i.e. unlikely to attract any documentation resource at all) when so many people have to use it to solve other difficulties with Excel data sources. -- Peter Jamieson http://tips.pjmsn.me.uk "Alan Olrog" wrote in message ... 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Office 2007 the single quotation mark changes the following let | Microsoft Word Help | |||
How to stop quotation mark autoformating to German umlauts | Microsoft Word Help | |||
Invisible Quotation Mark | Microsoft Word Help | |||
Drop capital and quotation mark | Microsoft Word Help | |||
Why do I get a double {{ instead of a quotation mark (")? | Microsoft Word Help |