Output Table Data to MS Word Document 1

[chris3942]

MS Word does a terrible job with Mailing Labels Using Mail Merge (Leaves Multiple minimized versions of Access open, etc). In Access, with a table open, there's a menu Selection: Tools/Office Links/MS Word that allows me to dump the data into the pre-defined Word Document to print labels. How can this be automated using VBA or a Macro get to the point that the MS Word document opens? Users don't have access to the tables so I need a way to automate around the opening of the table.

 

[cghoga]

try the following:

1 create a new macro
2 in the action column select OutputTo
3 at the bottom be sure to fill in the desired options
4 select your table from the Object Name list
5 to send it to Word choose Rich Text Format (*.rtf) in the Output Format field
6 in the Output File field I think you can specify the name of your file at the end of the path
(i.e. C:\YourFileName.doc).
7 be sure to set Auto Start to Yes so that the document will open automatically
8 Save the macro
9 To run the macro from code enter the following in your commmand button On Click event:

DoCmd.RunMacro "YourMacroNameGoesHere"

If the OutputTo action does not work for you, try the TransferText action. It is very similar to OutputTo.

hope this helps you.

 

[Rick39]

See

http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271

 

[chris3942]

Thanks to cqhoqa for the help. I may have been misleading in my question as I only wanted to output certain data to the label. Another tip referred me to

http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271

where I found code I was able to modify and send to "bookmarks" in my pre-defined label.