Hi kmcclell - don't appologise, there is so much that can be done in one or
another program nowadays that it's often difficult to work out where the best
place to do something is. However - you should be able to create an Access
Report that will do it all, and it is not really difficult.
First - a report is simply a printout - it can be 1 page and 1000, so can
work easily as a letter.
You can import graphics (ie your Publisher letterehead) onto the report
layout (actually you should also be able to do that on your Word Document so
should not have to print out from Publisher first in any case).
So - in Access create the Query that will give you the data you want (1
record or more) then save as Report. Import your letterhead, move the fields
around to where you want them on the Detail section of the Report Layout.

Once you've got to that point you can start looking into Buttons, etc. But
really all that is about is to attach a Macro or Code to a button that opens
the Report and runs it automatically. As I have done many it must be easy.
But take it step by step.

I hope this helps yuo get started - yell if you need more information ---

Yours --- Dika