Generate & print reports/forms
 

I have an access database of employee information that I am querying into Excel 2000 and reformating it so that we can print one page per employee with their vital information and availability. I tried using Access to print reports but I'm overwhelmed with access and don't understand a thing.

I created a macro to import the data and organized it with one employee per row.

John Smith 0055112 1111 Pacific Ave. Bellingham WA 98225 3601112345 Weeknights Weekdays Weekends
Suzie Que 2233421 2222 Atlantic St. Bellingham WA 98226 3602224567 Weekdays Weekends
etc.

I then have a form that looks at each row and displays one row at a time on the form. I created a button on the form for back/forward and if you press forward the form will update with the next employee's information.

I have a print button on the form that is a for/next loop and prints the first record, then goes to the next row and prints that form, then the next row and prints, etc. I have not had opportunity to fully test the printing feature yet, but my concern is that it will be very time consuming to for/next through 600+ employees and print each page one at a time.

Is there a way to create a report (vs. the form I have) that will import all the employees information keeping the same format? There are not enough rows in excel for me to just reformat the rows and columns and create a page for each row. I hope this makes sense. Thanks for any help you can provide.

Generate & print reports/forms
 

Chad,

Take a look at using Word's Mail Merge feature. Basically, you set up a
Word document with data fields, then merge your database into the document
and create a 600+ page document, that you can then simply print.

There are plenty of resources concerning mail merge on the web, and at
Microsoft.com.

HTH,
Bernie
MS Excel MVP

"Chad" wrote in message
...
I have an access database of employee information that I am querying into
Excel 2000 and reformating it so that we can print one page per employee
with their vital information and availability. I tried using Access to
print reports but I'm overwhelmed with access and don't understand a thing.

I created a macro to import the data and organized it with one employee
per row.

John Smith 0055112 1111 Pacific Ave. Bellingham WA 98225
3601112345 Weeknights Weekdays Weekends
Suzie Que 2233421 2222 Atlantic St. Bellingham WA 98226
3602224567 Weekdays Weekends
etc.

I then have a form that looks at each row and displays one row at a time
on the form. I created a button on the form for back/forward and if you
press forward the form will update with the next employee's information.

I have a print button on the form that is a for/next loop and prints the
first record, then goes to the next row and prints that form, then the next
row and prints, etc. I have not had opportunity to fully test the printing
feature yet, but my concern is that it will be very time consuming to
for/next through 600+ employees and print each page one at a time.

Is there a way to create a report (vs. the form I have) that will import
all the employees information keeping the same format? There are not enough
rows in excel for me to just reformat the rows and columns and create a page
for each row. I hope this makes sense. Thanks for any help you can
provide.