mailmerge - excel datasource - other file extension?

[Ralf Pickel]

hi,

mailmerge automation works fine when file extension of excel file is xls.
with other extension it will not. what can i do? renaming the file is not a
solution!

the solution must work with word 2000, XP, 2003.

i'd like to use dde (sample2).

thanks
ralf


code samples for word 2003 (german)
sample1:

oMailMerge.OpenDataSource _
Name:=Filename _
, ConfirmConversions:=False _
, ReadOnly:=False _
, LinkToSource:=True _
, AddToRecentFiles:=False _
, PasswordDocument:="" _
, PasswordTemplate:="" _
, WritePasswordDocument:="" _
, WritePasswordTemplate:="" _
, Revert:=False _
, Format:=wdOpenFormatAuto _
, Connection:="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Filename & ";Extended Properties=Excel 8.0;" _
, SQLStatement:="SELECT * FROM `Tabelle1$`" _
, SQLStatement1:="" _
, SubType:=wdMergeSubTypeOther

sample2:
oMailMerge.OpenDataSource Name:=Filename, _
Format:=CLng(0), _
ConfirmConversions:=CLng(0), _
ReadOnly:=CLng(1), _
LinkToSource:=CLng(0), _
AddToRecentFiles:=CLng(0), _
PasswordDocument:="", _
PasswordTemplate:="", _
Revert:=CLng(0), _
WritePasswordDocument:="", _
WritePasswordTemplate:="", _
Connection:="Gesamte Arbeitsmappe", _
SQLStatement:="", _
SQLStatement1:="", _
SubType:=wdMergeSubTypeWord2000

 

[Cindy M -WordMVP-]

Hi Ralf,

mailmerge automation works fine when file extension of excel file is xls.
with other extension it will not. what can i do? renaming the file is not a
solution!

the solution must work with word 2000, XP, 2003.

i'd like to use dde (sample2).

DDE almost certainly will not work, as it relies on the system recognizing
the Excel application, and that depends to a certain extent on the
application being associated with the file extension.

ODBC could, possibly, work if you define a DSN to use the file extension (or
even exact file path and name - a file DSN).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail