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 / February 2007

Tip: Looking for answers? Try searching our database.

Default delimiters saved in word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anthony Ricciardi - 21 Feb 2007 16:41 GMT
I want the Word Mailmerge to not prompt for field and record delimiters, but
to remember the last set of delimiters used. It seems to remember if I am
doing (comma, enter) delimiters but I am trying to use (pipe,enter) as the
delimiters and I have to reselect this each time. Is there anyway around this?

Thanks for your help
Anthony
Peter Jamieson - 21 Feb 2007 22:56 GMT
As far as I know the only way to do this is to change the connection method
that Word uses to get the data to ODBC, and set up the field delimiter in a
SCHEMA.INI file in the same folder as your data file. However, the ODBC
driver has some limitations compared to the built-in text converter (e.g.
you can't have multiline text fields, and ODBC will probably limit you to
255 fields).

If you want to try that, create or edit the SCHEMA.INI file in the folder
containing your file (let's say it is called myfile.txt). You need a section
in the SCHEMA.INI file like this:

[myfile.txt]
ColNameHeader=True
Format=Delimited(|)
MaxScanRows=25
CharacterSet=ANSI

or possibly

[myfile.txt]
ColNameHeader=True
Format=Delimited(|)
MaxScanRows=25
CharacterSet=OEM

(or use the locale ID of the character set you need).

Then check Word Tools|Options|General|"Confirm conversions at open", go
through te conneciton process again, and select the (Delimited?) Text files
via ODBC option when it is offered.

Your only other option is to preprocess the text file in some way, e.g. read
it into a .mdb or link a .mdb table to it in Access. But if the ODBC
approach does not work, that will probably not be easy either.

Peter Jamieson

>I want the Word Mailmerge to not prompt for field and record delimiters,
>but
[quoted text clipped - 5 lines]
> Thanks for your help
> Anthony
 
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.