Printing Report in word

Novice

Board Regular
Joined
Mar 18, 2003
Messages
53
Hi,
I have a word document which is a template for printing out labels. Instead of printing the document and writing in serial numbers I created an access database and used it's autonumber facility.
I also have another drop down list which the user can select parts from.
The word document consists of 16 labels in two rows of eight. I have copied this into a report and dragged the autonumber and part which the user enters on the database into the report. I have set up the report to ask the user what numbers to enter, eg 1 to 16, 16 to 20 etc.
When I go to print this report it is coming out on a number of pages, I need to have all the data on one page.
Is there a way of directly matching word documents into access and then adding two pieces of information using access?
Thanks
Novice
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
I don't know if this will help you, but have you tried creating the labels directly from Access instead of Word? It is pretty easy. In Access help, check out the Creating Mailing Labels section under Reports.
 
Upvote 0

Forum statistics

Threads
1,221,544
Messages
6,160,431
Members
451,646
Latest member
mmix803

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top