Best way to print a template

[bobhaha]

Hey guys, first post here!

I have been working on a inventory management system for a friend of mine. It has to be able to keep track of incoming and outgoing stock from his business.

I have already got all the programing done, working great! But now it has got to the stage, that I need the program to print out invoices from the program. I have the program extract certain records from an attached database, and will most probably pass them into a variable in the function.

NOW... I have a template of the tax invoice page setup in MS word. I was going to make a macro in word that will automatically fill in all the "static" information, but I was wondering if passing the variables from the main program into the word macro is: 1. possible and 2. the best way of doing this.

I am still a noob when it comes to VB so please excuse the next question, but is there a way to set up a page to be printed including tables, logo, different font styles.. etc within the VB program?

If at all possible I want to stay clear of the MS word idea, but is that the easiest way of doing this?

Thanks in advance!