As far as I know, neither leading nor trailing spaces will reach Word
from Excel no matter which connection method you use (DDE, ODBC, OLE
DB), except maybe the old Excel converter will do it for .xls files.
However, if you use Excel Insert tab-Symbol (at the end)-Special
Characters to insert "n-spaces", they should reach Word via the default
OLE DB connection. If, however, you also need to use DDE to connect,
they will be converted into "?" characters.
Unfortunately, something also seems to strip "non-breaking space"
characters which would probably be a better option as they are the same
width (AFAIK) as ordinary spaces. But you may find 2 n-spaces, an
m-space+an n-space or some such works for you.
Peter Jamieson
http://tips.pjmsn.me.uk
Lightjag wrote:
I have constructed a number of sentences in excel. Each sentence represents
a field that I ref in my mail merge doc.
Issue: Depending on the situation some sentences are needed and some are
not, so putting a double space after each field in word, may result in 4
spaces after a sentance if one field/sentence is not needed. When I add
spaces to the sentences in excel, word during the mail merge process
removes/ignors the spaces. Any thoughts?
Thanks in advance