How can I output an Access 2007 label to a Word 2007 file?

I have created an Access label but I want to send the output as a Word file to someone. How can this be done?
Who is Participating?
als315Connect With a Mentor Commented:
If you have report with labels, you can use docmd.sendobject. There are no DOC format, but you can use RTF:
DoCmd.SendObject acReport, ReportName, acFormatRTF

If you like to have more flexible documents, you can find some samples here:
Look at Access-Word section
Jeffrey CoachmanMIS LiasonCommented:
Curious as to why you need to do this...  

Outputting to word might introduce some formatting differences, and this may throw all the labels off

Also know that each time you run the labels in Access, Access checks the source tables for the most recent data, so in this case, you would have to output to Word each time you view the labels in Access...(to make sure the labels are up to date...)
dovidfCEOAuthor Commented:
I need to order the labels down and then across but Word 2007 doesn't allow for this while this is easy in Access 2007. The user wants to print the labels himself but doesn't have the hardware or software for Access so I need to send him a Word type of file.

The data is provided to me fixed by the user so there is no data update issue.
Jeffrey CoachmanMIS LiasonCommented:
Then give als315's post a shot, looks promising...
dovidfCEOAuthor Commented:
The sendobject worked great. Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.