dovidf
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
The data is provided to me fixed by the user so there is no data update issue.
Then give als315's post a shot, ...it looks promising...
;-)
;-)
ASKER
The sendobject worked great. Thanks
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...)