Exporting some data fields to MS Word

[Chrisma]

I have 5 word template ready. I need to export the following field from MS Access 2000 to MS Word 2000.

Lastname, First name, Company Name,Address and position

I need to do it in VB code.

please guide me on how to do it in function.

 

[formerTexan]

Chrisma,

There are several ways and if you do an archive search you will turn up the code details. Perhaps the easiest approach is to set bookmarks in the Word doc. Then in VB/VBA, open the Word doc, open a recordset, reference the bookmarks and pass the data.

Cheers,
Bill

 

[Chrisma]

hi Bill,

can you guide me which site i can find a VBA sample code for this.

I have a bookmark to all my word template, now I need a sample code on how to do it in VBA.


thanks for your help

 

[formerTexan]

Hi Chrisma,

Here is a link. THe article reminded me that you will need to set a reference to Word in the reference library.

http://groups.google.co.za/group/mi...160211dd1b092be?sa=X&oi=groupsr&start=2&num=3

Cheers,
Bill

 

[Chrisma]

Thanks FormerTexan.

Its really a great help