Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Default delimiters saved in word
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Default delimiters saved in word
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 "Anthony Ricciardi" wrote in message ... 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up delimiters in my Word data file? | Mailmerge | |||
italics replacement with delimiters | Microsoft Word Help | |||
When I open Word, a saved document opens as the default window. W | Microsoft Word Help | |||
Header Record Delimiters fails . . . | Mailmerge | |||
Disappeearing Delimiters | Mailmerge |