Leading whitespace in data being stripped out "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> 4/26/2007 11:23:17 PM 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

Re: Leading whitespace in data being stripped out "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 4/27/2007 7:47:07 AM I would suggest that you put the tab in the appropriate place in the mail merge main document. -- 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 "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> wrote in message news:%237EoZnFiHHA.1312[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > 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 >

Re: Leading whitespace in data being stripped out "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> 4/27/2007 4:28:46 PM 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 "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message news:uVYMMBKiHHA.5008[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] >I would suggest that you put the tab in the appropriate place in the mail >merge main document. > > -- > 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 > > "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> wrote in message > news:%237EoZnFiHHA.1312[ at ]TK2MSFTNGP03.phx.gbl... >> 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 >> > >

Re: Leading whitespace in data being stripped out "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 4/27/2007 4:48:39 PM 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 "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> wrote in message news:%237EoZnFiHHA.1312[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > 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 >

Re: Leading whitespace in data being stripped out "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> 4/27/2007 5:30:22 PM MS Access database file. Kevin Bilbee "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message news:uozpxuOiHHA.4772[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > 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 > > "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> wrote in message > news:%237EoZnFiHHA.1312[ at ]TK2MSFTNGP03.phx.gbl... >> 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 >> > >

Re: Leading whitespace in data being stripped out "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 4/27/2007 6:55:00 PM 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 "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> wrote in message news:OTE88GPiHHA.4676[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > MS Access database file. > > > > Kevin Bilbee > > > > "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message > news:uozpxuOiHHA.4772[ at ]TK2MSFTNGP05.phx.gbl... >> 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 >> >> "Kevin Bilbee" <kbilbee[ at ]standardabrasives.com> wrote in message >> news:%237EoZnFiHHA.1312[ at ]TK2MSFTNGP03.phx.gbl... >>> 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 >>> >> >> > >