Reply
 
Thread Tools Display Modes
  #1   Report Post  
Ralf Pickel
 
Posts: n/a
Default mailmerge - excel datasource - other file extension?

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



  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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 :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 6th 05 12:23 AM
word 97 mailmerge with paradox files as datasource saj via OfficeKB.com Mailmerge 0 December 24th 04 01:14 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 10:02 AM
Mailmerge from EXCEL, custom format problem TonyB Mailmerge 1 December 1st 04 05:41 PM
To select data from across worksheets in a excel file for a main . Salaivani Mailmerge 1 December 1st 04 02:08 AM


All times are GMT +1. The time now is 06:58 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"