Publisher/Word/Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm such a neophyte! I've looked through the Access Discussion groups, but
can't find a situation quite like ours.

We print all our letterhead from a Publisher file. When we book a tour, the
name, address, date and time of scheduled tour, etc., is entered into Access.
We then print a Word form letter on our letterhead. Is there any way to
streamline this three-part process?

I have checked through the Access Discussion groups and have found lots of
confusing stuff about reports, codes, and buttons when generating form
letters from Access. As if that weren't confusing enough, I'm hoping to
print these form letters on our Publisher letterheaed. Any suggestions to
get me started will be MOST appreciated!
 
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
 
Back
Top