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?
LVL 4
dovidfCEOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

als315Commented:
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:
http://helenfeddema.com/CodeSamples.htm
Look at Access-Word section
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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...)
0
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.
0
Jeffrey CoachmanMIS LiasonCommented:
Then give als315's post a shot, ...it looks promising...
;-)
0
dovidfCEOAuthor Commented:
The sendobject worked great. Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.