[AccessD] Need booklet type report

Tina Norris Fields tinanfields at torchlake.com
Mon Apr 7 06:52:42 CDT 2008


Kathryn,

When I needed to do this for a membership directory, I did it this way:
1) I wrote my query to select the specific information I needed for my 
records,
2) I used mail merge to drag those records into Word in a catalog (one 
of the mail-merge wizard choices - form letter, labels, catalog),
3) I inserted the merged Word document into Publisher booklet and did 
lots of formatting and hand-editing to make things look the way I wanted,
4) I printed in booklet form.

The final booklet was to be printed by a commercial print-shop that 
didn't know how to work with Publisher, so the final trick was to 
convert my Publisher document to a PDF file.  It worked out very well.

I hope this is helpful,
Tina

Kathryn Bassett wrote:
> Four years ago, I had help from the list to make a report that included pictures. However, that report only worked for me as a proof for several reasons, one of which is that it is plain 8.5x11. I ended up having to use WordPerfect to pull in the information from Access to do what I wanted to do, because I could figure out how to do it there.
>
> Now, I need to do another version (of my church photo directory), and I've lost the WordPerfect template form that did the work. So, before I go to the trouble of recreating it, I thought I'd see if you all can help with doing what needs doing either self contained in my mdb or in conjunction with Word (I only can do easy stuff in Word). I'd rather have a Word template to do the work so I can do further editing.
>
> First - versions. Access2003, though ABCtest.mdb in http://www.altadenabaptist.org/problems/photodir is Access2000 format because I never had reason to update it. I have Word2003 as well.
>
> Second - Obviously I'm not including the photos, so for testing you'll need to put a picture someplace and copy the path into the photo field of the members table for all the people.
>
> Now, on to what I need, which is a report that will print in booklet format. http://www.altadenabaptist.org/problems/photodir/diretory1.jpg shows a scan of the central pages from the old directory.
>
> Ultimately, when it comes to actual printing, I will need to print things like this:
> Left	Right
> 20	1
> 2	19
> 18	3
> 4	17
> 16	5
> Etc
>
> Every entry has a Lastname and Firstname, and some people have a Connections field filled in. I do NOT want the word Connections to print if that field is blank. See the Larson, Lebsch and McCall entries in the above jpg for example.
>
> I need to have this done before the end of April so I'm hoping that one of you is willing to work with me to do this.
>
> Oh, a side anomoly. Though all my paths start with O:\Online\abc\photos, they used to start with D:\MyFiles\Online\abc\photos. When I open the report that's currently in the mdb, it comes up with an error that "Microsoft Office Access can't open the file 'D:\MyFiles\Online\abc\photos\b\bassettdavid.jpg'." I can't find anyplace where that is, so why does it say that? If I click ok, it then goes on to make the report.
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net   
>
> No virus found in this outgoing message.
> Checked by AVG. 
> Version: 7.5.519 / Virus Database: 269.22.7/1361 - Release Date: 05 Apr 08 7:53 am
>  
>
>
>   



More information about the AccessD mailing list