Automate Word OLE32 merge printing with Ruby

ruby-talk
1

What I would like to do is automate merge print documents without user
interference.

I have come so far:

  fso = WIN32OLE.new("Scripting.FileSystemObject")
  word = WIN32OLE.new('Word.Application')
  path = fso.GetAbsolutePathName(ARGV.first)
  doc = word.Documents.Open(path)
  path = fso.GetAbsolutePathName('some.xls')
  doc.MailMerge.OpenDataSource(path)

My questions:
At the line:
  doc.MailMerge.OpenDataSource(path)
Words asks for choosing table (which is actualy a worksheet in excel
file). How can this be supresses or set automaticaly?

How to print all resulting documents?
Recorded macro says:
With ActiveDocument.MailMerge
   .Destination = wdSendToPrinter
   .SuppressBlankLines = True
   With .DataSource
      .FirstRecord = 1
      .LastRecord = 1
   End With
   .Execute Pause:=False
end

by
TheR

···

--
Posted via http://www.ruby-forum.com/.