CopyFromRecordset

J

Jose Perdigao

Is it possible use this method or similar method to copy recordset to MS Word?

Another away to copy data to word is with merging, but I don't know how can
I do.

any suggestion I'll apreciaste,

Thanks
JP
 
P

pietlinden

What did you plan to do with the recordset once it's in Word? create a
table out of it? Use it as a source for mail merge? Fill in a Word
form?

there's an example of creating invoices in Word in Access Developer's
Handbook , if you look in the chapter on automation.,
 
J

Jose Perdigao

The data is stored in mdb database and the entry data is done in mdb database.

The mdb database generate many reports in excel spreadsheet using automation.

But I need generate few reports in word because the data is based in
comments and the data type is memo.

I would like create a word template and then from mdb, I should click a
button and the data should export to word and then should open it and shows
the data

I don't have the book mentioned.
have you an example?

Thanks,
JP
 
P

pietlinden

If I were you, I'd at least read the chapter on automation at the
bookstore. I'd buy it. As anybody here who has done any serious
development in Access, it's required reading. Based on what you sem to
already know, you would get a lot out of it. And you could adapt the
code in the database for the automation chapter to suit your needs.

One of the things the code does is converts an ADO recordset to a table
in Word.

So you could just modify it to suit your needs.

I think the book is a bargain, even at $50 or so.

Anybody else want to pitch in?

Pieter
 
Top