Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mailmerge char delimiter

Status
Not open for further replies.

pit75

Programmer
Jun 3, 2003
15
US
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
 
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 input file first rows must contain the names of the fields , separated by the field delimiter (keep it in mind!!!); 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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top