Linking data to word

[access man]

Hi all,

I have a situation here and want to find the best solution. Everyday I have to do a report about stock market. The figures I take out from my database, and I do my commend in word 2007.

I want my word document template automatically link the data from Access database, so I just have to type my comment. At the moment, I have to copy and paste the figures from access to word document and it take a lot of time.

Please help me,

Thanks all,

 

[Mike375]

I am always interested in this topic myself as I think there must be better ways than I currently use.

The following is what I do and perhaps someone can point out a better way.

You can put a query into Word. Click on the query in the query window and copy. You are not copying the query contents when is is open but the query itself. Open your Word. doc and select Paste Special and then Link when the box opens. Each time the word.doc is opened it will show the current query results.

The downside to this is formatting how it looks and especially if the query has several records and the number of records will vary. If you think you could have up to 10 records then make a dummy query with 30 records and use that to format. Writing under the query will move up or down dependiing on number of records.

Another way is insert the Access field data into Word Bookmarks. This requires VBA and is a nice way to go but is messy if you have to insert data from more than one record and is extra messy if there are varying number of records.

Another way to insert into bookmarks is with DDESend. The formulas are entered into unbound textboxes and they work when the form is opened. These are real simple to do for either Word or Excel

=DDESend("WinWord","c:\Letters\0AMPMike.doc","a4",[ExExp])

=DDESend("Excel","c:\Letters\ModePayment.xls","R3C3",[ExExp])

In both case the Access field [ExExp] data is being inserted......"a4" is the Word Bookmark and "R3C3" is the location of the Excel cell

Another way to go is to use the Access mail merge feature. Tools>>Office Links

If you use Bookmarks/VBA then you don't save the Word.doc as the entries will be saved in the Bookmarks. DDESend will override whatever entries are in the Bookmarks.