View Single Post
  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default From Access to Word merge

Hi Oakleyp2,

is this not how i would do it??

oDoc.MailMerge.OpenDataSource _
Name:="", _
connection:="DSN=forms;DBQ=c:\re\support.mdb;", _
SQLStatement:="SELECT * FROM tblsupport", _
Subtype:=wdMergeSubTypeWord2000

This looks like it could work. I'm not sure I'd expect to
see wdMergeSubTypeWord2000, but if it works, it works :-)

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