Word removes leading spaces

[Ganesh S]

Hi folks,

When mail merging documents, Word removes the leading
spaces from the columns. My data source is created in word.

Does anyone have a workaround ?

Thx

Ganesh

 

[Doug Robbins - Word MVP]

Use Edit>Replace on the data source to replace the spaces with non-breaking
spaces.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Ganesh S]

Hi doug,
I tried that, but still its taking out the leading spaces
when i look at the data form.

thx
Ganesh

 

[Cindy M -WordMVP-]

Hi Ganesh,

I tried that, but still its taking out the leading spaces
when i look at the data form.

Which version of Word is this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Ganesh]

Hi Cindy,

I'm sorry to say this,
its Word 97

-----Original Message-----
Hi Ganesh,

Which version of Word is this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail


.

 

[Cindy M -WordMVP-]

Hi Ganesh,

I'm sorry to say this,
its Word 97

OK, I needed to find some time to test...

When I set up a Word TABLE, and put the data directly into
the table cells, all spaces are retained. And I also see
them in the "data form".

How did you create your data source?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Guest]

ok, i'm creating the data source dynamically through Power
Builder. So my data source doesn't look like table cells,
its freeform and seperated by tab characters.

 

[Cindy M -WordMVP-]

ok, i'm creating the data source dynamically through Power

Builder. So my data source doesn't look like table cells,
its freeform and seperated by tab characters.

In this case, Word always strips leading and trailing spaces.
The data must be in a Word table in order to retain
leading/trailing spaces.

You could open the tab delimited file in Word, select the
records, then Table/Convert Text to Table... IF you don't
have more than 63 columns/fields.

VBA (a macro) could also handle this, to make it a bit less
painful

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Guest]

Cindy, thanks for the reply

-----Original Message-----
In this case, Word always strips leading and trailing spaces.
The data must be in a Word table in order to retain
leading/trailing spaces.

You could open the tab delimited file in Word, select the
records, then Table/Convert Text to Table... IF you don't
have more than 63 columns/fields.

VBA (a macro) could also handle this, to make it a bit less
painful

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

.