Access To Word VBA code

[Dan688]

Hello all
I am trying at a click of a button in Access to export data within a table into Microsoft Word.
I know that I will have to use VBA but can someone help me out with this?

 

[MakeItSo]

Have a go with Word Mail merge.
[ul][li]Create a suitable query in Access,[/li]
[li]Create a new Mail merge document in Word,[/li]
[li]choose Access as data provider,[/li]
[li]choose your query as data source.[/li]
[/ul]
Voilà! No VBA needed. ;-)

Cheers,
Andreas

[blue]The last voice we will hear before the world explodes will be that of an expert saying:
"This is technically impossible!" - Sir Peter Ustinov[/blue]
andreas.galambos@bowneglobal.de
HP:

http://andygalambos.de

 

[MakeItSo]

P.S:

If you need something more sophisticated, you could also try with creating A Word document with bookmarks at certain positions.
Them through Access VBA,
create a word instance opening your doc, and assign the respective values to the bookmarks.

If you don't know how to, do a quick keyword search in the Access VBA forum forum705 . This topic has been discussed several times, so you should find good solutions there.

Good luck,
Andy

[blue]The last voice we will hear before the world explodes will be that of an expert saying:
"This is technically impossible!" - Sir Peter Ustinov[/blue]
andreas.galambos@bowneglobal.de
HP:

http://andygalambos.de