Opening up Word , linked to spreadsheet data.

S

Staunts

Hi there,

I have a project where I want to export some field data from MS Access
as an excel document.

I then want to be able to launch a word document based on the contents
of that spreadsheet. The spreadsheet will only have 1 row of data
(about 10 fields in total).

Is there some way I can "force" word to use this data when opened,
rather than have to use the merge button etc.

I don't want any user interraction and basically just want to print the
"populated" word document at the click of a button (from within
access).

any help would be greatly appreciated.

cheers,

Adam
 
Top