Migrating from Word mail merge to Access Reports


Hi folks,

I'm trying to help convert a fairly cumbersome MS Word<>MS Access mail merge
process to an "all Access" solution. The office has several packets for
clients that consist of 8-10 pages each of printed info that is customized
to the clients' own info via a typical mail merge. However, the process
keeps breaking, especially in terms of having to re-establish the link from
the main document to the data source and then filter it for the right
clients.

My thought was to move this to Access, create a form to filter the records
in an easier fashion than having someone manually look through the record
list (using a form for criteria) and then producing however many packets are
needed, fully "merged" and so on. For example...

pg 1 Client Encounter Form
pg 2 Client Action Items
pg 3 Office Information and Next Appointment
.... and so on for 8-10 pages.

I thought I'd put all of pages of one packet into one report and end up with
3 separate reports, one for each 8-10pg packet. That's when I bumped into
the 22" vertical size limit for an Access report.

My next thought was to make each page a separate report, which I could do
easily enough but then we end up having someone on staff having to collate
the packets. That is, I had thought about using a macro to print each of
the reports in succession and that's what leads to someone having to collate
the packets (i.e. print report 1 for 10-100 people, then print report 2 for
10-100 people and then someone has to go through 2 x 10-100 print jobs and
add report 1 to report 2 for person 1, then add report 1 to report 2 for
person 2, etc.)... because I don't know of a way in Access to make it
"perfect".

Am I stuck with that trade-off vs. living with the dysfunctional system or
are there other options I haven't considered?

Thanks in advance!

Anth


.

Relevant Pages

  • Re: Migrating from Word mail merge to Access Reports
    ... The CanGrow works fine but it still prints all clients' ... A report is limited to 200 inches in height ... controls in the group header and footer and some in the details section. ... many packets are needed, ...
    (microsoft.public.access.reports)
  • Re: Multicast or not
    ... AliR wrote: ... I have one server application which needs to talked to ... > server application needs to send the exact same packets to all the clients, ... > events and the threads would send the packets. ...
    (microsoft.public.vc.mfc)
  • Solaris 9 connection problems
    ... The server is behind a firewall which is not under ... my control although I am assured that the subnet that the test clients ... On the server I see the Syn packets arriving and Syn Ack and Ack packets ... I'm also confused why this is affecting connections from some clients ...
    (SunManagers)
  • Re: [RFC/PATCH] IMQ port to 2.6
    ... Shaping works much better: ... > much less packets dropped, much better donwload rates for clients. ... I mean the ethy interface not the ppp* interfaces. ...
    (Linux-Kernel)
  • Re: [RFC/PATCH] IMQ port to 2.6
    ... I have not seen anything in favor of shaping; ... much less packets dropped, much better donwload rates for clients. ... I want to shape traffic that comes from upstream to clients connected ...
    (Linux-Kernel)