PDA

View Full Version : Specifing a delimiter in mailmerge doc


pit75
11-18-2004, 05:31 AM
I've created a word mailmerge document;
The problem is : every time I reopen the document , it demands me which record an field delimiters I want to use.
This obviuosly makes me impossible to automate the entire process. Does not exist the way to specify the delimiters characters from VBA (i've tried to record a macro from word, repeating all the operation above, but I didn't go far: no delimiters in macro) Someone has suggestions? Thanks in advance

pit75
11-19-2004, 09:21 AM
I've noticed this:
the problem is that the mailmerge document, for being saved correctly, needs that the input file specifies the field name contained in the template itself.
In other words:
The input file is a database,really, and it needs every field name used by the template mail-merge document.

So the firsts rows of input file must contain the names of the fields , separated by the field delimiter (!!!); then it must contain the record delimiter, and finally the true input data to be read.

If you have the input file in similar way, you can then make the mail merge operation, and save it. So ever time you open this document, word doesn't ask again to specify the delimiters.
bye