Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2007

Tip: Looking for answers? Try searching our database.

Leading whitespace in data being stripped out

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin Bilbee - 27 Apr 2007 00:23 GMT
We just upgraded from Office 2000 to 2007 and our merge data that started
with a tab character now seems to be ignoring\striping the leading tab
character. This character is used for formatting.

How do I get office 2007 to not ignore\strip leading whitespace characters?

Kevin Bilbee
Doug Robbins - Word MVP - 27 Apr 2007 08:47 GMT
I would suggest that you put the tab in the appropriate place in the mail
merge main document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> We just upgraded from Office 2000 to 2007 and our merge data that started
> with a tab character now seems to be ignoring\striping the leading tab
[quoted text clipped - 4 lines]
>
> Kevin Bilbee
Kevin Bilbee - 27 Apr 2007 17:28 GMT
OK my bad. Sometimes ther is data infront of the tab. So placing the tab in
the document will not work.

The places this happens we are prefomatting multi-line data so it will wrap
properly on the page.

Any other suggestions?

Kevin Bilbee

>I would suggest that you put the tab in the appropriate place in the mail
>merge main document.
[quoted text clipped - 7 lines]
>>
>> Kevin Bilbee
Peter Jamieson - 27 Apr 2007 17:48 GMT
To be honest, I can't remember which types of data source used to preserve
white space at the beginning of fields, but what type of file is your data
source?

Peter Jamieson

> We just upgraded from Office 2000 to 2007 and our merge data that started
> with a tab character now seems to be ignoring\striping the leading tab
[quoted text clipped - 4 lines]
>
> Kevin Bilbee
Kevin Bilbee - 27 Apr 2007 18:30 GMT
MS Access database file.

Kevin Bilbee

> To be honest, I can't remember which types of data source used to preserve
> white space at the beginning of fields, but what type of file is your data
[quoted text clipped - 10 lines]
>>
>> Kevin Bilbee
Peter Jamieson - 27 Apr 2007 19:55 GMT
Check Word Tools|Options|General|"confirm conversions at open", go through
the process of connecting to your database again, and select the DDE option
when offered.

Peter Jamieson

> MS Access database file.
>
[quoted text clipped - 14 lines]
>>>
>>> Kevin Bilbee

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.