T
Tom Brooks via OfficeKB.com
I have several word templates (.dot) generated with Word95/97. I am now
using Word 2003. I support a large application which allows customer
service reps to generate letters. There is an embedded macro (using
WordBasic) for each template which calls mailmerge. The data source as it
is todya uses ' for field delemiter and ~ for record delemiter. With Word
2003 the defaults are TAB for field delimeter and ENTER for record
delimeter. Consequently, after the .dot is opened, mailmerge fails and the
end user must use Mail Merge Helper to alter the delimeters, then run Mail
Merge. Per Microsoft suggestion, I am reformatting my data source to use
commas as field delimeters and paragraph mark as record delimeter. However,
with this new method the data source must be a text file (.txt). When mail
meger runs, I get the ever unpopular popup stating an and SQL select * from
data source 'filename'.doc statement will be run.
How can I alter the data source filename to indicate the .txt extension,
while continuing to use WordBasic?
using Word 2003. I support a large application which allows customer
service reps to generate letters. There is an embedded macro (using
WordBasic) for each template which calls mailmerge. The data source as it
is todya uses ' for field delemiter and ~ for record delemiter. With Word
2003 the defaults are TAB for field delimeter and ENTER for record
delimeter. Consequently, after the .dot is opened, mailmerge fails and the
end user must use Mail Merge Helper to alter the delimeters, then run Mail
Merge. Per Microsoft suggestion, I am reformatting my data source to use
commas as field delimeters and paragraph mark as record delimeter. However,
with this new method the data source must be a text file (.txt). When mail
meger runs, I get the ever unpopular popup stating an and SQL select * from
data source 'filename'.doc statement will be run.
How can I alter the data source filename to indicate the .txt extension,
while continuing to use WordBasic?