Simplest way to create a report to look like a mail merge document

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike NG (sweepdog_at_deadspam.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 17:01:04 +0000

I believe from doing google searches and setting up some practice Forms,
I'm in a position to replace my rather clunky database written in Excel
VBA (using Forms) c/w an excel data*** with an Access system

One thing I had as part of this was a mail merge main document which I
called (c/w writing an appropriate data file). This was very easy to
set up as I just typed as I would a normal document, format it, printed
it to test it, and adjust it appropriately

Obviously the way to go in Access would be a report. The wizard is a
bit of a pain cos I don't need the field names, have to delete the
footers and headers etc, have to delete the red record separator and
insert the page break character.

Design mode isn't a right lot better, but is there an easier way where
you can effectively get an A4 *** and type the data as you go along
where things like left justification are done automatically for you -
otherwise you have to rely on the align and spacing options which is a
bit naff in my opinion

Also, I have looked in the help for "mail_merge" and it says this
        In the Database window, click the name of the table or query
        (Access database only) you want to export, and then on the Tools
        menu, point to Office Links and click Merge It With MS Word.
but I can't for the life of me see this menu either with a table or a
query selected, and I do have the menu fully dropped with
not-so-recently-accessed items visible. Has anyone else seen this in
Office 2000 

-- 
Mike
Please post replies to newsgroup to benefit others
Replace dead spam with ntl world to reply by email
Quantcast